LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I hide unused file types from file types list in save dial Estra Q Excel Discussion (Misc queries) 1 December 17th 09 12:36 PM
what types of source data can't be grouped in pivottable Group items in a PivotTable Excel Discussion (Misc queries) 0 September 2nd 09 10:31 AM
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Charts and Charting in Excel 15 June 2nd 09 10:53 AM
checkbox on form reset from checkbox on sheet raw[_12_] Excel Programming 1 December 3rd 05 05:08 AM
checkbox "Always trust macros from this source" shaded out Valeria Excel Programming 7 January 27th 05 10:59 AM


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"