Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to manipulate some embedded activeX controls
(comboBox) on a worksheet. Refer some sample coded below: Dim w As Worksheet Set w = ActiveWorkbook.Worksheets("help") ActiveWorkbook.Worksheets("help").cboX.AddItem = "test" w.cboX.AddItem = "again" Line 3 works fine, and adds the text "help" to the combo box. Line 4 which I would have thought was identical, fails even to compile! Due to the nature of the task at hand it will be much neater if I can get the code given (or like) line 4 to work. Any ideas? Thanks Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
Tab between ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) |