PDA

View Full Version : Solved: How to reset Drop-Down (combo box)



Fan
08-21-2011, 07:28 PM
Hi,

In Excel 2007, I create some dropdown box by using Developer/Insert Combo box(Form control). It actually called 'Drop Down' in the formula bar.
(PS. I tested insert the combo box (ActiveX control) which is called 'Combo Box' in the formula bar. )

I know this might be a really simple and popular question. I did some search on Google but no appropriate solution up there, as most of them are for ealier version of excel. And it called 'Drop Down' rather than 'combo box'.

To be more clear, it is not the drop down from 'data validation'. Those drop down only show the arrow when you click the cell. Drop Down button from Form control will display that arrow and you can change the height of that.

Could someone help me with the VBA code to reset the drop down list to the first value, please?

Thank you so much in advance.

Regards,

Fan

mikerickson
08-21-2011, 10:50 PM
ActiveSheet.Shapes("Drop Down 1").ControlFormat.Value = 1

Fan
08-21-2011, 11:05 PM
Thank you, mikerickson.

That simple code works great! Really appreciate!!:bow: