| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to an ActiveX control
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referring to an ActiveX control
Thankyou Jacob. I was close but no smell of cigar smoke. Brett
"Jacob Skaria" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referring to an ActiveX control
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" 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Referring to an ActiveX control
I see, thanks Joel. Btrett
"joel" wrote: 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" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| publish activeX combobox and other activeX control | Excel Programming | |||
| How to control "Date Time Picker ActiveX Control" | Excel Programming | |||
| ActiveX Control | Excel Programming | |||
Linear Mode
