Fordraiders
asked on
Textbox with combobox selection choices
Excel 2010 vba
Userform
Multipage Tab Specifically "page 9"
Textbox1
8 comboboxes
Combobox1 to Combobox8
Scenario:
Comboxes are filled with items.
Not All comboboxes are filled
Combobox1 to combobox 5 may only contain items at times..
What I need:
As i make selections in the comboboxes.
I need the Textbox to be updated with the choices from the comboboxes.
With a seperation character semicolon ;
Combobox1 selected = drill
Combobox3 selected = 1/2 inch
combobox6 selected = brown
The the result in the Textbox could be:
drill;1/2 inch;brown
Thanks
fordraiders
Userform
Multipage Tab Specifically "page 9"
Textbox1
8 comboboxes
Combobox1 to Combobox8
Scenario:
Comboxes are filled with items.
Not All comboboxes are filled
Combobox1 to combobox 5 may only contain items at times..
What I need:
As i make selections in the comboboxes.
I need the Textbox to be updated with the choices from the comboboxes.
With a seperation character semicolon ;
Combobox1 selected = drill
Combobox3 selected = 1/2 inch
combobox6 selected = brown
The the result in the Textbox could be:
drill;1/2 inch;brown
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Open in new window