Command Button

V

vijay22

How do I create a command button in a worksheet and assign a command t
it using the control box tools, e.g., to sort a list of figures in
sheet?

Thank you,

vija
 
D

Don Guillett

The macro recorder is your friend. Just use tools>macros>record when you do
your sort manually. Then, assign to a button or a shape. I do not recommend
command buttons.
 
B

Bob Phillips

Control toolbox controls have events associated with them. After creating
the control, you will be in design mode, so double-click the control, and
that will take you to the sheet code pane with the default event (Click for
a button) filled out. Just add your code to it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
D

Dave Peterson

Or use a button from the Forms toolbar and just assign the macro (in a general
module) to that button.
 
Top