Control Toolbox vs Forms
What are the main reasons to use the controls from control toolbox instead of from forms? Please advice
Peter |
Control Toolbox vs Forms
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 |
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 |
Control Toolbox vs Forms
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 |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com