Thanks Dave.
I have printed-off your explanation and will go through word for word.
You have made things much clearer.
Jim

"Dave Peterson" wrote:

Record a macro when you add a checkbox from the forms toolbar to a worksheet.
Then continue recording when you add a checkbox from the Control toolbox
toolbar.

Then look at the code. You'll see that the "Forms.checkbox.1" is used to
indicate the ActiveX version of the checkbox. That's the same type of controls
that are used in UserForms.

And if you see something like:

dim Oleobj as oleobject
with activesheet
for each Oleobj in .oleobjects
if typeof oleobj.object is msforms.checkbox 'ok
as opposed to
if typeof oleobj.object is checkbox 'won't work ok

A plain old checkbox is from the Forms toolbar. The msforms.checkbox is from
the control toolbox toolbar. The code is specifying which checkbox to compare
with.





JMay wrote:

I'm working with some code that

Controls.Add("Forms.Checkbox.1")

What does the word "Forms" above indicate?

I know there are the controls which are created on a sheet-only via Toolbar
Forms;
There are also controls from the Control toolbar (onsheet or Userform
-Active Xtype).

Then sometimes I see in Code "MSForms"... How can I better understand and
figure these things out? Help!!

--

Dave Peterson