WebGuy
05-30-2006, 03:49 AM
Hello!
I would like to be able to control a userform with a combobox. Depending on what option i choose in the combobox, i want to fill in the corresponding values in textboxes.
The values are all stored in an excel sheet as follows
Combobox Textbox1 Textbox2 Textbox3
A 1 6 11
B 2 7 12
C 3 8 13
D 4 9 14
E 5 10 15
So if i choose A in the combobox , i want the values 1, 6 and 11 to be loaded in the textboxes.
Thank you !
:beerchug:
I would like to be able to control a userform with a combobox. Depending on what option i choose in the combobox, i want to fill in the corresponding values in textboxes.
The values are all stored in an excel sheet as follows
Combobox Textbox1 Textbox2 Textbox3
A 1 6 11
B 2 7 12
C 3 8 13
D 4 9 14
E 5 10 15
So if i choose A in the combobox , i want the values 1, 6 and 11 to be loaded in the textboxes.
Thank you !
:beerchug: