| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
add option to drop down menu
I currently have a drop down menu/combo box in excel and I would like to add
more selections to the drop down menu. Appreciate any hep |
|
#2
|
|||
|
|||
|
Try this
Private Sub ComboBox1_GotFocus() ComboBox1.Clear ComboBox1.AddItem "Item 1" ComboBox1.AddItem "Item 2" ComboBox1.AddItem "Item 3" End Sub "Vic" wrote: I currently have a drop down menu/combo box in excel and I would like to add more selections to the drop down menu. Appreciate any hep |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down menu containing worksheet names | Excel Worksheet Functions | |||
| XML Data menu option -- not listed / available. How do you fix thi | Excel Discussion (Misc queries) | |||
| Applying a formula to a drop menu choice | Excel Discussion (Misc queries) | |||
| How do I set up a drop down menu for a validation list? | Excel Worksheet Functions | |||
| when a menu option ends in.... a dialogue box will appear what ar. | Excel Worksheet Functions | |||
Linear Mode
