MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COMBOBOX in VBA: how reset the default value????

Posted by Walter on June 10, 2001 11:35 PM

I have a combobox, related to a range of value (blank included), linked to a cell. Is it possible, in VBA, to restore its default value (blank) after updating its value with different value?

Posted by Walter on June 11, 2001 5:11 AM

I found the statement that occurred me!

ComboBox1.ListIndex = 0

where 0 is the first column of array associated to the combobox.

I hope my solution will be good for everybody.