Setting a list of values

[patupatu]

Hello. Is ther a way to use a file, let us say a list o customers, as a combo? WHat I am trying to say is, so I don't have to explicitly write down the values to como up on a pull down, but the values come from a long list set aside.

Thank you in advance

 

[Ruddles]

What do you mean by "file"? Text file? Excel workbook?

You can do this in one of two ways:-

• If the file is text, read it as text and load it into a combobox one item at a time using .AddItem
• import the file into a worksheet and set the combobox's .RowSource to point to the appropriate range of cells

 

[patupatu]

Thank you. It is a workbook file. I'll try your suggestion.

 

[Ruddles]

It's nearly midnight here and I'm off to bed.

If you get stuck, shout.