how can i fill a combo box with values from a file?
Posted by combo on July 19, 2001 8:15 AM
i have list of files with data like:
id,name,more data...
the file length is varid and the names are not unique in the file.
i want to display all the names in the file in a combo box for the user to choose from (after he chose the file of data he wants to work on)
what i did is to import the data into a sheet,
and then used the combobox_gotFocus sub to go over the names
and only add the unique names from it to the combobox.
the problem is that when i click on the combobox
excel imports the data to another place in the sheet do the sub and then i used scrollRow to go back to the combobox, and it makes the screen blink and jump from one place to another.
im sure theres a better way doing it..