Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button vs Form Button
Hi
I'm uncertain as to when I should be using CmdButtons from the Control Toolbox vs when I should be using Buttons from the Forms Toolbar. It seems I can assign code that works fine to either one. I know this is a genereal question, but are there clear guidelines as to which button is best for what sort of task? Are there times when one type of button should be avoided? Thanks Bri |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button vs Form Button
I almost exclusively use cmdButtons from the control toolbox. They are easier
to deal with since they can be easily referenced in code. They have more properties and methods to play with. The only reason I would ever use the buttons from the forms toolbar is if I needed the code, that the button is attached too, to not land in the sheet. This happens if you want to copy the sheet to another book or such. -- HTH... Jim Thomlinson "Bri" wrote: Hi I'm uncertain as to when I should be using CmdButtons from the Control Toolbox vs when I should be using Buttons from the Forms Toolbar. It seems I can assign code that works fine to either one. I know this is a genereal question, but are there clear guidelines as to which button is best for what sort of task? Are there times when one type of button should be avoided? Thanks Bri |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button vs Form Button
Adding to Jim:
Controls from the Toolbox will only work properly in Window 1. So if there's a chance of multiple windows use of a sheet, avoid controls on it and use the Forms items. HTH. Best wishes Harald "Bri" skrev i melding ... Hi I'm uncertain as to when I should be using CmdButtons from the Control Toolbox vs when I should be using Buttons from the Forms Toolbar. It seems I can assign code that works fine to either one. I know this is a genereal question, but are there clear guidelines as to which button is best for what sort of task? Are there times when one type of button should be avoided? Thanks Bri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro attached to command button - VBA form | Excel Discussion (Misc queries) | |||
User form and Command button | Excel Discussion (Misc queries) | |||
Command Button on User form for Printing | Excel Discussion (Misc queries) | |||
Access data form through command button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |