I have a userform wherein the textbox1 value is entered by the user and this should give a vlookup value in the other textbox2. My sheet name is master and the range name is TOB.
Need assistance in the above might be a formula.
Once I get the value in textbox2 I need a selection range in my combobox1 as per the range allotted to the value received in textbox2.
Textbox1 = 01
Textbox2 = Shoes Size (Master has range with 01=Shoe Size / 02=Wardrobe / 03=Clothes)
Combobox = 8,9,10,11 (Master has range Shoe Size=1,2,3,4,5,6,7,8,9,10,11,12,13 / Wardrobe=Pant, Shirt, Tie, etc. Clothes=Peter England, Nike, Puma)
Please help in the above.