View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wesandem wesandem is offline
external usenet poster
 
Posts: 1
Default Macro relative to button position

Is there a way to make a macro relative to a button position? I want t
have a macro input a set value into a cell that is beside the button.
The sheet I am desiring has hundreds of buttons that all do the sam
exact thing - place an "X" into the cell beside the button - I don'
feel like writing hundreds of individual macros, so I am hoping ther
is a way to make the action relative to the button, not absolute o
relative to the currently selected cell, which are the only two option
i know of.
Please help - this is driving me nuts! THANKS

--
Message posted from http://www.ExcelForum.com