G
Guest
What are the main reasons to use the controls from control toolbox instead of from forms? Please advice
Peter
Peter
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Peter,
IMO, control toolbox controls are more flexible (e.g. that have multiple
events, you can change colours), but forms are simpler to use.
Personally, I never use forms controls, although there are other luminaries,
such as Dave Peterson (and Tom Ogilvy?) who are hugely experienced and
influential posters here, who I believe prefer forms controls. The choice is
yours, so suck it and see is the best advice I can give.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
IMO, control toolbox controls are more flexible (e.g. that have multiple
events, you can change colours), but forms are simpler to use.
Personally, I never use forms controls, although there are other luminaries,
such as Dave Peterson (and Tom Ogilvy?) who are hugely experienced and
influential posters here, who I believe prefer forms controls. The choice is
yours, so suck it and see is the best advice I can give.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
T
Tom Ogilvy
Just to add, since I was mentioned.
If you are going to use the control on the worksheet, particularly if you
are going to be adding them with code or need to use a single event to
handle their click event or if a combobo or listbox, need to dynamically
change the list, then in my opinion, forms controls are much easier to work
with and more reliable and more closely integrated with Excel's object
model.
ActiveX controls offer a lot more options in terms of formatting and
control.
If you are going to use the control on the worksheet, particularly if you
are going to be adding them with code or need to use a single event to
handle their click event or if a combobo or listbox, need to dynamically
change the list, then in my opinion, forms controls are much easier to work
with and more reliable and more closely integrated with Excel's object
model.
ActiveX controls offer a lot more options in terms of formatting and
control.
O
onedaywhen
Adding to Bob and Tom, I too prefer the ActiveX controls (Controls
Toolbox) because I get more control. However they tend to have some
strange bugs associated with them e.g. if you change the screen
resolution then dropdown a combobox it keeps doubling in size, you
can't reliably set a checkbox's value in code in Excel2002, etc.
Controls from the Forms toolbar are safe and reliable but are much
less for developers e.g. the underlying code must be a public sub in a
standard module and I hate writing those things!
--
Toolbox) because I get more control. However they tend to have some
strange bugs associated with them e.g. if you change the screen
resolution then dropdown a combobox it keeps doubling in size, you
can't reliably set a checkbox's value in code in Excel2002, etc.
Controls from the Forms toolbar are safe and reliable but are much
less for developers e.g. the underlying code must be a public sub in a
standard module and I hate writing those things!
--