Excel VBA. Simple Combo Box

Matthew Miele · 10-13-2008, 02:57 PM

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!

10-13-2008, 02:57 PM	#1
Matthew Miele HyperActive Warrior Join Date: Sep 2007 Location: , , United Kingdom. Posts: 161 Thanks: 0 Thanked 0 Times in 0 Posts	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!