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: 3,986
Default Control Toolbox vs Forms

The big difference is that you can set properties with the controls from the
Control Tool Box whereas the Forms controls properties are pretty much fixed.
There is also a difference in how the code is attached. The Forms controls
usually give you an opportunity to attach an existing macro when you select
the control from the tool bar. The Tool Box controls allow you to right
click the control and develop the code after you have selected the control.
My personal preference is the Tool Box controls.

"Jon Crawford" wrote:

What exactly is the difference between the Control buttons and the Form
buttons? I know the Controls work off of events, so does that mean my code
has to be within the Sheet, and not the Module?

I had code attached to a radiobutton in the Sheet, my boss wanted me to
remove it and place in Module, at which point the macro quit working.
Replacing it to the Sheet made it work again.

I'm thinking that the difference is being able to call the Controls
dynamically while the Forms must be physically activated? Or is it just less
than one way to skin a cat?

 
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
difference between forms and control toolbox Manikandan Excel Discussion (Misc queries) 1 June 18th 07 04:03 PM
forms toolbar vs. control toolbox anny Excel Programming 1 May 9th 06 02:31 AM
What's the difference between Control Toolbox and Forms widgets? Joseph Geretz Excel Programming 10 April 6th 06 11:55 PM
Difference of Control toolbox / Forms ? Ming[_3_] Excel Programming 1 March 15th 05 05:56 AM
Control Toolbox vs Forms Peter Excel Programming 3 February 5th 04 04:28 PM


All times are GMT +1. The time now is 03:42 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"