View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Checkbox - Source types

Forms is the name of the userform where the checkbox is located. If the
checkbox is on a worksheet, then you need to add a tool bar as follows:View -
toolbars - Control Toolbox. Then enter design mode and select properties.
Then click on the userform to see the properties.


User forms can also be added in VBA. In the project managger window you can
insert a userform. If a userform exists the to view the userforms in VBA
click on userform in the project manager window.

"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!!