Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello group,
I am using this code to generate a listbox in a worksheet. The only problem is that the listbox is from the Forms toolbar. ================================================== =================== Application.CommandBars("Control Toolbox").Visible = True ActiveSheet.OLEObjects.Add(ClassType:="Forms.ListB ox.1", Link:=False, DisplayAsIcon:=False, Left:=114, Top:=105, Width:=90, Height:=125.25) ..Select Application.CommandBars("Control Toolbox").Visible = False ================================================== ==================== I require the Linked Cell function of the Control Listbox . I used the Macro record for this code. Thanks, Michael Singmin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error: Value in Formula of wrong data type | Excel Worksheet Functions | |||
Wrong data type | Excel Discussion (Misc queries) | |||
Where am I going wrong? - Date type function. | Excel Worksheet Functions | |||
Type mismatched in Listbox | Excel Programming | |||
Populating multicolumn listbox the wrong way | Excel Programming |