View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VicWestVan VicWestVan is offline
external usenet poster
 
Posts: 10
Default How to I reference in VB a button used to run an Excel macro

Is there a way to reference objects in a VB macro that have been assigned the
same macro?

My application involves several different objects in a worksheet used to
launch a macro that differs only slightly depending on which object is
clicked. If I can ID the object in the code, I can combine the different
macros and just include some IF..THEN statements relating to the object
clicked.

Thx...