View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default macro for button option

That button must run a macro so some sort. Just add the line

Call MyMacro

Where MyMacros is the name of the procedure you want executed.
--
HTH...

Jim Thomlinson


"peyman" wrote:

hi,
I have a command box on my worksheet and I wanna record a macro like
scrolling down a file and then choosing a button option for the command
box.I do the same after selecting "record new macro" but only scrolling down
is saved in the macro!!and the button is not chosen?
any help in this regard?
thanx,
peiman