Excel VBA. Simple Combo Box
Hey,
Im trying to make a userform with a combolist on it that displays the contents of Column A (well from A5 downwards). but there are duplicates in that cell range so I only want the combolist to display unique entrys.
Then when the user selects the option from the list and clicks OK button on the user form.
It opens a csv file which is in thisworkbook.path & "/Data/"
the filename is the same as the value selected in the combolist.
if the file does not exist a message box comes up says so.
Is anyone could help me with this that would be great!
Im trying to make a userform with a combolist on it that displays the contents of Column A (well from A5 downwards). but there are duplicates in that cell range so I only want the combolist to display unique entrys.
Then when the user selects the option from the list and clicks OK button on the user form.
It opens a csv file which is in thisworkbook.path & "/Data/"
the filename is the same as the value selected in the combolist.
if the file does not exist a message box comes up says so.
Is anyone could help me with this that would be great!