Referring to an ActiveX control

[Brett]

How do I set the focus to a control in worksheet please?
F_REF.Shapes("APP1_reset").SetFocus
doesn't work - it bugs out with "...doesn't support..." (F_REF has been set
as the sheet name and APP1_reset is the control name. Brett

 

[Jacob Skaria]

Dear Brett

Refer the shapes with its index or its name

Activesheet.shapes("Rectangle 1").Select

OR

Activesheet.shapes(1).Select

 

[Brett]

Thankyou Jacob. I was close but no smell of cigar smoke. Brett

 

[joel]

OLE obejct can be reference by OLEOBJECTs("Listbox1").object

OLEOBJECT are both shapes and OLEOBJECTs. The object get you to the
properties that you normally see for a list box without the object it is the
shape properties.

 

[Brett]

I see, thanks Joel. Btrett

OLE obejct can be reference by OLEOBJECTs("Listbox1").object

OLEOBJECT are both shapes and OLEOBJECTs. The object get you to the
properties that you normally see for a list box without the object it is the
shape properties.