View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default 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