Hi,
I am working on a simple user input form in Excel at the moment and everything is going along swimmingly, until I was informed that the users must be able to select Multiple categories from a combobox.
The categories are held in a separate sheet in the format of Column 1 = 3 digit alpha Column 2 = Description Var
What I need to know is if it is possible to select multiple values from the combobox(This can be done one at a time), and then insert the selected multiple categories into a single cell separated with a comma.
The big problem I am having with this is that the end user form will be used in Excel for MACs and I am using a Windows PC to create the form.
Any thoughts or suggestions are appreciated.
Cheers
FBICFC
I am working on a simple user input form in Excel at the moment and everything is going along swimmingly, until I was informed that the users must be able to select Multiple categories from a combobox.
The categories are held in a separate sheet in the format of Column 1 = 3 digit alpha Column 2 = Description Var
What I need to know is if it is possible to select multiple values from the combobox(This can be done one at a time), and then insert the selected multiple categories into a single cell separated with a comma.
The big problem I am having with this is that the end user form will be used in Excel for MACs and I am using a Windows PC to create the form.
Any thoughts or suggestions are appreciated.
Cheers
FBICFC