"hmm" wrote in message
...
A few questions about Forms and Controls; I use Excel 2000. I have used
them
successfully before, but in a limited capacity; I would like to expand my
comprehension of them.

1. What is the difference between Forms and Controls? There seems to be a
bit of overlap.


Forms controls are more integrated within Excel, and so are probably easier
to use. Control toolbox controls are more flexible, for instance you can set
their background colour, but are harder. For most purposes, Forms controls
should suffice.


2. Can elements from both the Forms and Control toolboxes be used in the
same worksheet?


Absolutely.


3. a) In the Forms toolbar, there is an item called a Group Box. What is
it, besides a nice way to organize the visual presentation of your
controls?
Is there a way to change the font size of its title?


It does what it says, it Groups controls. This can be especially useful for
OptionButtons, as only one is set at any time. With groups, you have only
one within THAT groups set, a big difference.


b) Same questions for the Label. Is it anything besides a text box, and
can
its font size be changed?


Another disadvantage of the Forms controls, no textbox. Either use a drwaing
bar textbox, or a controls toolbox.

4. Why is Edit Box in the Forms toolbar always disabled? Sometimes I want
to put a text entry box in a chart, and I can't use the Text Box control
because the Control toolbar is completely disabled for charts.


That control is not available, so I have no idea why it is there, but see
previous answer.


5. Is there a better general description of the function and application
of
these two toolbars; Excel Help didn't give me adequate information.


Hopefully, I have given it <G