LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Difference between a Forms Control verus Active-X Control

The controls from the forms toolbar are part of XL. You attach macros from
modules directly to the control. This can be handy as the controls are not
embeded in the sheet and they do not place any code in the sheet.

Controls from the control toolbox are embeded objects. If you are fimiliar
with VB6 these controls are almost identical to the controls you would embed
in a userform. Since these controls are embedded they place their code
directly in the sheet. The up side is that they have a rich set of properties
and methods. Much more than controls from the forms toolbar.

99% of the time I use controls from the controls toolbox as I like the rich
set of properties and methods and the easy of referencing the controls in
code. That is not to say the forms controls don't have a place though.

--
HTH...

Jim Thomlinson


"funGT350" wrote:

What is the difference Between a Forms Control versus an Active-X Control?
(e.g. a Combo Box from the Forms Toolbar versus a Combo Box from the Control
Toolbox Toolbar?) Why would one use one versus the other?

 
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
Forms Control captsamm(remove)@comcast.net Excel Discussion (Misc queries) 1 February 13th 08 10:37 PM
difference between forms and control toolbox Manikandan Excel Discussion (Misc queries) 1 June 18th 07 04:03 PM
active x calendar control WYN Excel Discussion (Misc queries) 0 March 5th 07 03:05 AM
Active X Calendar Control JMay Excel Discussion (Misc queries) 2 January 21st 07 11:02 PM
how to set active x control sharlie Excel Discussion (Misc queries) 0 March 30th 06 01:27 AM


All times are GMT +1. The time now is 07:49 AM.

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"