Command Button

[vijay22]

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

Thank you,

vijay

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"vijay22" <vijay22.27abnm_1146749101.1772@excelforum-nospam.com> wrote in
message news:vijay22.27abnm_1146749101.1772@excelforum-nospam.com...
>
> How do I create a command button in a worksheet and assign a command to
> it using the control box tools, e.g., to sort a list of figures in a
> sheet?
>
> Thank you,
>
> vijay
>
>
> --
> vijay22
> ------------------------------------------------------------------------
> vijay22's Profile:
> http://www.excelforum.com/member.php...o&userid=34114
> View this thread: http://www.excelforum.com/showthread...hreadid=538853
>

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

"vijay22" <vijay22.27abnm_1146749101.1772@excelforum-nospam.com> wrote in
message news:vijay22.27abnm_1146749101.1772@excelforum-nospam.com...
>
> How do I create a command button in a worksheet and assign a command to
> it using the control box tools, e.g., to sort a list of figures in a
> sheet?
>
> Thank you,
>
> vijay
>
>
> --
> vijay22
> ------------------------------------------------------------------------
> vijay22's Profile:
http://www.excelforum.com/member.php...o&userid=34114
> View this thread: http://www.excelforum.com/showthread...hreadid=538853
>

[Dave Peterson]

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

vijay22 wrote:
>
> How do I create a command button in a worksheet and assign a command to
> it using the control box tools, e.g., to sort a list of figures in a
> sheet?
>
> Thank you,
>
> vijay
>
> --
> vijay22
> ------------------------------------------------------------------------
> vijay22's Profile: http://www.excelforum.com/member.php...o&userid=34114
> View this thread: http://www.excelforum.com/showthread...hreadid=538853

--

Dave Peterson