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
|