toolbars: form vs control

[AFJr]

ok, i see the control toolbox has detailed properties that i can modify. the
forms toolbox only has a few. so, a few questions in regards to checkboxes:

i read in a previous post that to many checkboxes from the control tool box
could cause problems, ah, why?

when is it appropriate to use form vs control tools?

i am modify an existing spreadsheet with many checkboxes on it, maybe 50-75.
the sheet is cramped and the text to small. these are "form" checkboxes. the
problem is that i cannot modify the text size for the checkbox. i was
thinking of changing these to "control" checkboxes where i can modify the
size of the text. i'm a little hesitant to do this since i don't want to
cause problems after reading that post.

from the post i read:
"The dropdown from the forms toolbar has lots fewer options but seems to be
better behaved when there are lots of controls on the worksheet."

any discussion or suggestion on this would be appreciated.

 

[challa prabhu]

Hi,

A. Forms toolbar can be placed in the document. You can assign a Macro to
the Forms Control using the Assign Macro dialog box. There is no design mode
and run time mode. Forms are used within the Worksheet.

B. Control Toolbox are usally used in the UserForm- for developing
Application, where you write code for a particular Control using the Visual
Basic Application for Excel. There are two modes - Design Mode and Runtime
Mode.

Challa Prabhu