Referring to an ActiveX control

  • Thread starter Thread starter Brett
  • Start date Start date
B

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
 
Dear Brett

Refer the shapes with its index or its name

Activesheet.shapes("Rectangle 1").Select

OR

Activesheet.shapes(1).Select
 
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.
 
I see, thanks Joel. Btrett

joel said:
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.
Click to expand...
 
Back
Top