Run a macro by the number typed in a box/button
 

I want to create a box or button in which I may type a number to run th
associated macro.
For example: My goal is to sort data for each day of the month. I ma
currently create 31 macro's and 31 buttons, but I would like to have on
button/box to run the day that is in need of sorting. I will have 3
macro's, but only one button. Is this possible

--
mcicof
-----------------------------------------------------------------------
mcicoff's Profile: http://www.excelforum.com/member.php...fo&userid=3450
View this thread: http://www.excelforum.com/showthread.php?threadid=54271

Run a macro by the number typed in a box/button
 

I know this may be slightly longer winded than just a text box sat o
the screen but hope this helps or at least points in the righ
direction...

Keep your button on the sheet and have it call the Macro "InputBox"
-------------
Sub InputBox()
macro = Application.InputBox("Enter Macro Number")
Run ([macro])
End Sub
------------

Clicking your button will now open an input box which asks for th
macro name you would like to run. If you had a macro called "Print" an
entered Print in this box then that macro would run.

Joh

--
johncassel
-----------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...fo&userid=2501
View this thread: http://www.excelforum.com/showthread.php?threadid=54271

Run a macro by the number typed in a box/button
 

How about

Application.Run "Macro" & Day(Date)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mcicoff" wrote in
message ...

I want to create a box or button in which I may type a number to run the
associated macro.
For example: My goal is to sort data for each day of the month. I may
currently create 31 macro's and 31 buttons, but I would like to have one
button/box to run the day that is in need of sorting. I will have 31
macro's, but only one button. Is this possible?


--
mcicoff
------------------------------------------------------------------------
mcicoff's Profile:
http://www.excelforum.com/member.php...o&userid=34504
View this thread: http://www.excelforum.com/showthread...hreadid=542711