Form Fields or Controls?

[Guest]

Good day. I am going to use Excel 2002 to create a Pricing workbook with the
following 4 worksheets:
1) Customer Information Form: Data to be entered by external users
2) Price Quote Form: Will use data from #1 and quote pricing based on #4 &#5
4) Product Pricing Matrix: To be locked and hidden from users
5) Product Pricing Matrix II: To be locked and Hidden from users

My questions today concerns the creation of the 1st worksheet. The form will
have, check boxes, option buttons, drop down boxes, Etc.....

In general, is it better to use items from the Controls Toolbox Toolbar or
the Forms Tolbar? My inclination is to use Controls because of the ability
to add code.

At this point in my project I am most interested in designing a form that
esthetically pleasing, functional and can be scalable should things change.

Thank you for your time.

 

[Jon Peltier]

I generally use Forms Toolbar controls, or at least I used to. They've been
around longer, and on rare occasions funny things happen when there are
Controls Toolbox things on the sheet. Forms controls can be placed on a
chart sheet, and can be assigned to macros.

Controls Toolbox controls have some nice features, though. They are more
readily formatted, and they are more instantaneous: using a forms slider,
the linked cell doesn't update until you release the mouse, whereas the
controls toolbox scrollbar changes the cell as you move it.

I guess the answer is, whichever works.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______