Thread: An easy one!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 18
Default An easy one!

This file might be a help:
http://www.bygsoftware.com/examples/...s/apcaller.zip
It's in the "Worksheet with VBA" section on page:
http://www.bygsoftware.com/examples/examples.htm

A short demo that reports which of three buttons was pressed

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"Dr. Schwartz" wrote in message
...
I have 16 contol buttons that all launch the same sub. How can I make the

code recognise which button was pressed?

Is there a way to rename (not the text) a button differently from what

Excel assigns?

Any help is appriciated
Schwartz