Thanks, Bob, for your helpful answers.

Just a follow up:

Can I change the font size of the Group Box title?

What is the intended purpose of the "Label" item in the Forms toolbar?

I do not see any "toolbox" in the Controls toolbar. Perhaps it has another
name?

Regarding the Edit box, I could use it to link the input to a cell; I don't
think a text box can do that, can it?

I would still like to read see more basic descriptions and examples of all
these controls; if you know of any resources, I would appreciate a link.

Thanks.




"Bob Phillips" wrote:


"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