What are the main reasons to use the controls from control toolbox instead of from forms? Please advice
Peter

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

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

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!

--

"Tom Ogilvy" wrote in message ...
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