Form Fields or Controls?

[David Cahill]

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/
_______

"David Cahill" <dcccahill@[email protected]> wrote in message
news:[email protected]...
> 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.
>
>
>
>
>
>