Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox on a Sheet
Apologies for sort of a newbee question.
I want to 1. place a combo box onto a worksheet, 2. populate it with some values, 3. execute some VBA upon selection. Creating a DialogBox with a ComboBox isn't an option. It has to be on a Sheet. The recorder creates the ComboBox as : ActiveSheet.OLEObjects.Add(ClassType:="Forms.Combo Box.1", Link:=False, _ DisplayAsIcon:=False, Left:=67.5, Top:=275.25, Width:=63, Height:= _ 40.5).Select Once ActiveSheet is set, how do is this ComboBox accessed using VBA? And how do I add an option item? And get the selection. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RowSource for Sheet ComboBox | Excel Worksheet Functions | |||
How do I put hyperlinks to another sheet in a combobox? | Excel Discussion (Misc queries) | |||
Sheet combobox help | Excel Worksheet Functions | |||
combobox/copying sheet | Excel Discussion (Misc queries) | |||
ActiveX ComboBox Control on Sheet | Excel Programming |