Which button & when/where to use
 

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.


--
Thank you

Bob C
It cost''''''''s little to carry knowledge with you.

Which button & when/where to use
 

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.
--
Gary''s Student - gsnu200778


"Bob C" wrote:

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.


--
Thank you

Bob C
It cost''''''''s little to carry knowledge with you.