Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbars: form vs control
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. -- TIA AFJr |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbars: form vs control
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 "AFJr" wrote: 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. -- TIA AFJr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form control - check box | New Users to Excel | |||
control form macros and protected sheets | Excel Discussion (Misc queries) | |||
Drop Down Form control always causes excel to crash | Excel Discussion (Misc queries) | |||
Using form control names in SQL | Excel Discussion (Misc queries) | |||
How do I set up and use a group box form control? | Excel Discussion (Misc queries) |