View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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