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.

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

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?

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

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.

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

"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

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

"hmm" wrote in message
...

Just a follow up:

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


I would assume that it takes some windows setting, you can't change it
directly on its own.


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


Just to add a lable if you are creating a worksheet that looks like a form.
Bit superfluous IMO.


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


The Controls Toolbox is whaty I mean by that toolbar, it is called taht when
you look at ToolsCustomize.


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?


No, you need the RefEdit control for that, additional controls.


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.


I don't know of one, but I will post back if I find one.