Button, Button, which Button?

P

Phil Hageman

Once installed on a worksheet, how do you tell
a "CommandButton" from the Controls Toolbox from
a "Button" from the forms toolbox?
 
J

John Walkenbach

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
 
C

Chip Pearson

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 (e-mail address removed)
 
P

Phil Hageman

Chip, Thanks for the reply. Mine are from the Forms
Toolbar - trying to learn more about how to use them.
Phil
 
P

Phil Hageman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top