Referring to an ActiveX control
Dear Brett
Refer the shapes with its index or its name
Activesheet.shapes("Rectangle 1").Select
OR
Activesheet.shapes(1).Select
--
If this post helps click Yes
---------------
Jacob Skaria
"Brett" wrote:
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
|