command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have recently used a sum by color function which
requires the user to press "ALT F9" to execute. I am
trying to create a command button that, when clicked,
would execute this command. So far I have;

"%{F9}",True

I am having trouble writing the rest of the code to get
this function to work. Any ideas?

Thanks
 
Hi
you may use
sub foo()
sendkeys "%{F9}",True
end sub

or just add the line
application.volatile
to your colorindex function
 
Back
Top