ExcelBanter - add option to drop down menu

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - add option to drop down menu (https://www.excelbanter.com/excel-discussion-misc-queries/13891-add-option-drop-down-menu.html)

Vic

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

Ramakrishnan Rajamani

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

All times are GMT +1. The time now is 07:18 AM.