Using a Macro to make a combobox selection

  • Thread starter Richard Clayton
  • Start date
R

Richard Clayton

From within a VBA macro, I want to select an option from within
dropdown list (combobox), so that once the macro has run, the combo bo
is reset ready for the next use.

The combo box is populated from a static range within the sam
worksheet.

For example:

Choose Name
Andrew
Brian
Charlotte
Diana

I want the Combo Box to be set by the macro to "Choose Name".

I have checked through the info on the forum and some is relevant but
cannot get syntax etc quite right. I get error messages that say Objec
not defined etc. (Still learning!). I have tried Dim cb As Object, an
various other futile forays into the unknown.

The Combo box appears to be named "DropDown2" - automatically.

Would be very grateful for a little help!

Thanks

Richard Clayto
 
Top