Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button, Button, which Button?
Once installed on a worksheet, how do you tell
a "CommandButton" from the Controls Toolbox from a "Button" from the forms toolbox? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button, Button, which Button?
Right-click it and check the shortcut menu that appears. If the menu has
"Assign macro" on it, then it's from the Forms toolbar. John Walkenbach For Excel tips, macros, & downloads... http://j-walk.com/ss "Phil Hageman" wrote in message ... Once installed on a worksheet, how do you tell a "CommandButton" from the Controls Toolbox from a "Button" from the forms toolbox? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button, Button, which Button?
Phil,
Do you mean how to tell the difference by looking at them? Right-click the button, and if you see "View Code", it comes from the Controls toolbar. Otherwise, it comes from the Forms toolbar. Or do you mean programmatically telling the difference between the two. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Phil Hageman" wrote in message ... Once installed on a worksheet, how do you tell a "CommandButton" from the Controls Toolbox from a "Button" from the forms toolbox? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks
Chip, Thanks for the reply. Mine are from the Forms
Toolbar - trying to learn more about how to use them. Phil -----Original Message----- Phil, Do you mean how to tell the difference by looking at them? Right-click the button, and if you see "View Code", it comes from the Controls toolbar. Otherwise, it comes from the Forms toolbar. Or do you mean programmatically telling the difference between the two. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Phil Hageman" wrote in message ... Once installed on a worksheet, how do you tell a "CommandButton" from the Controls Toolbox from a "Button" from the forms toolbox? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Problem Too
Hi John - glad to see you back on the NG. My Buttons are
from the Forms Toobar. I'm trying everything I can to clear a run-time error and thought maybe the button could have something to do with it. I posted earlier to this group, then again on the Charting group. Maybe you could look at the charting thread and suggest something. By the way - have ordered your charting book. Looking forward to better things. Phil -----Original Message----- Right-click it and check the shortcut menu that appears. If the menu has "Assign macro" on it, then it's from the Forms toolbar. John Walkenbach For Excel tips, macros, & downloads... http://j-walk.com/ss "Phil Hageman" wrote in message ... Once installed on a worksheet, how do you tell a "CommandButton" from the Controls Toolbox from a "Button" from the forms toolbox? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undo button and redo button quit | Excel Discussion (Misc queries) | |||
Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
Command Button vs Form Button | Excel Programming |