Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Forms controls from outside
Hi,
I will telecommand an excel application from another excel application. All works fine, except 2 combobox form controls, which I can't set from outside. How can I set a combobox form control in an App1 by code from my 2nd App? Set app1 = CreateObject("Excel.Application") Set wb1 = appSchein.Workbooks.Open("Test.xls") Set ws1 = wbSchein.Worksheets("Employees") app1.Visible = True ws1.Activate ws1.Shapes("combobox1").select ?????????????????? does not work SendKeys ("February") ?????????????????? Thanks Hans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX to Forms controls | Excel Discussion (Misc queries) | |||
Excel forms controls | Excel Discussion (Misc queries) | |||
Forms controls | Excel Worksheet Functions | |||
Forms Controls | Excel Programming | |||
Forms Controls | Excel Programming |