Combobox - selecting first row

[metalguy90]

I have a form with a combobox on my excel spreadsheet, and i was wondering how to when it starts, to have the first item in the combobox selected.

thanks,

 

[Juan Pablo González]

Try with

ComboBox1.ListIndex = 0

 

[metalguy90]

yeah... i tried that ... didnt seem to work....

i know in VB, ... there was a command called 'selected' ... i forgot how to use it... but there doesnt seem to be anything like that in VBA

 

[Juan Pablo González]

Where (and how) did you put the code? which toolbar did you use to insert the ComboBox ?