Control Toolbox vs Forms
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.
--
Regards,
Tom Ogilvy
"Bob Phillips" wrote in message
...
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)
"Peter" wrote in message
...
What are the main reasons to use the controls from control toolbox
instead
of from forms? Please advice.
Peter
|