| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ole Object Problems
I have inserted some objects in my sheet (combo box, option buttons)
This code works perfect: ActiveSheet.OLEObjects("CBoxConc").ListFillRange = "ProdProductos" But this one returns an error 438: ActiveSheet.OLEObjects("CBoxConc").Text= "MyText" This one returns an error 438 too: ActiveSheet.OLEObjects("CBoxConc").List Index = 1 Any help or suggestion??? Thanks in advance ! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ole Object Problems
ActiveSheet.OLEObjects("CBoxConc").object.Text= "MyText" ActiveSheet.OLEObjects("CBoxConc").object.Listinde x= 1 -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "RCL" wrote in message oups.com... I have inserted some objects in my sheet (combo box, option buttons) This code works perfect: ActiveSheet.OLEObjects("CBoxConc").ListFillRange = "ProdProductos" But this one returns an error 438: ActiveSheet.OLEObjects("CBoxConc").Text= "MyText" This one returns an error 438 too: ActiveSheet.OLEObjects("CBoxConc").List Index = 1 Any help or suggestion??? Thanks in advance ! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ole Object Problems
Bob Phillips ha escrito: ActiveSheet.OLEObjects("CBoxConc").object.Text= "MyText" ActiveSheet.OLEObjects("CBoxConc").object.Listinde x= 1 -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "RCL" wrote in message oups.com... I have inserted some objects in my sheet (combo box, option buttons) This code works perfect: ActiveSheet.OLEObjects("CBoxConc").ListFillRange = "ProdProductos" But this one returns an error 438: ActiveSheet.OLEObjects("CBoxConc").Text= "MyText" This one returns an error 438 too: ActiveSheet.OLEObjects("CBoxConc").List Index = 1 Any help or suggestion??? Thanks in advance ! Thank You Bob...very kind... it works fine ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with Validation object Add and Modify methods | Excel Programming | |||
| problems using Filesearch object when files have a password | Excel Programming | |||
| Problems returning Collection object | Excel Programming | |||
| Rectangle object in Worksheet not amenable to word indenting and Undo problems | Excel Discussion (Misc queries) | |||
| Problems Defining Object Variable in For Each Loop | Excel Programming | |||
Hybrid Mode
