Command Button

[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

 

[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.

 

[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)

 

[Dave Peterson]

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