Excel 97 macro ComboBox

M

Mikael

I have a Excel97 worksheet where I have some fields where user adds some values
and a combobox that is linked to row with values.

I have made a macro "Empty" that erases all the values from the cells.
I allso want that same macro to change the combobox value to
first value of the list.

I tried to add to my macro:

ComboBox1.ListIndex =0

But it will return an error.

Please tell me how to make this macro work.

Thanks in advance

Mikael
 
D

Dave Peterson

My first guess:

ActiveSheet.ComboBox1.ListIndex = 0

(or whatever sheet you're using)
 
Top