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