Read in data to a combobox

[daseffects]

I have a series of comboboxes on a form which I want to preselect or preload with data form the spreadsheet when the form is activated.

I've tried code in different variations to the below w/ no luck.

UserForm1.ComboBox3.text = Range("eventsdatabase!E2&quot.Value

D

 

[benlinkknilneb]

Don't know about Excel for sure, but everywhere else, there is a method within the combo box like this:

ComboBox3.Add("String&quot

So what you'd have to do is loop through your range and add each one manually.

Ben

"If thine enemy offend thee, give his child a drum." - Anonymous

 

[daseffects]

The combobox is already populated with a string. I just need the ability to preselect one or write in a value.

D

 

[benlinkknilneb]

Oh, to *select* the item...

Check out the ListIndex Property of the combo box. I think it may be what you need.

Ben

"If thine enemy offend thee, give his child a drum." - Anonymous