Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VB to change Combo box selection
From within a VBA macro, I want to select an option from within a dropdown list (combobox), so that once the macro has run, the combo box is reset ready for the next use. The combo box is populated from a static range within the same 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 I cannot get syntax etc quite right. I get error messages that say Object not defined etc. (Still learning!). I have tried Dim cb As Object, and 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 Clayton -- Richard Clayton ------------------------------------------------------------------------ Richard Clayton's Profile: http://www.excelforum.com/member.php...o&userid=15122 View this thread: http://www.excelforum.com/showthread...hreadid=267610 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box selection will not calculate | Excel Discussion (Misc queries) | |||
Multiple Selection Combo Box | Excel Discussion (Misc queries) | |||
multiple selection in combo box | Excel Discussion (Misc queries) | |||
Combo box wont change selection? | Excel Programming | |||
combo box close on selection help!! | Excel Programming |