Excel 97 macro ComboBox

  • Thread starter Thread starter Mikael
  • Start date Start date
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
 
My first guess:

ActiveSheet.ComboBox1.ListIndex = 0

(or whatever sheet you're using)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Iterating through a ComboBox's values 6
Userform problem (Listindex) 1
How do i get the value from a comboxbox and link it to print. 0
ComboBox Code Error 4
Duplicating of Message Boxes 5
Use match function to add different item in Combobox 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top