Which button & when/where to use

  • Thread starter Thread starter Bob C
  • Start date Start date
B

Bob C

Hi
using Excel 2007

What is the difference between a Command Button and a Form Control Button?
What is the criteria used in choosing one over the other?

I use a Form Control Button in the Quick Access Toolbar that allows me to
quickly add a button onto the worksheet page and record a macro to "This
Workbook".

Am I correct in using the button this way?

It seems to works ok, but should I be using a different button/method.
I cleanup the recorded code to stop "select" happening where ever possible
and my knowledge of VBA allows.
 
What you are doing is fine. Forms buttons ae easy to set up. Another fun
thing to try is to first create the macro in a standard module. Then put any
AutoShape on the sheet. You can right-click the Shape and assign the macro
to it.

You can resize the Shape, color it, etc. Neater than a boring button.
 
You must log in or register to reply here.

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

Similar Threads

'Cannot insert object' message when I try to put a button on a worksheet 7
How to use multiple command button to copy user form data to multiple worksheet 0
How to access macros via tool buttons? 2
Button & Labels text Anti-aliasing Problem using Windows Forms C# 0
Open Specific Worksheet Using Button Form Control in Excel 0
Command Button - Shrinking Font 1
Customizing Form Control Button in 2007 1
command buttons disappear when I move worksheet 2007 1

Back
Top