ActiveX controls are objects of the sheet they're used on...
Sheet1
CheckBox1
...refs as Me.CheckBox1 in the code module behind the sheet. By default,
when you right-click the control in design mode you get...
Private Sub CheckBox1_Click()
End Sub
...in the code window. IOW, working with AX controls on a sheet is
similar to working with the same control on a userform. There are a few
differences like the worksheet version not having a Tag property, for
example, whereas the userform version does.
Forms controls are Shape objects, and so must be ref'd as such by their
string name (or index in the shapes collection).
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion