View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Finding Row or Button Name

Hi Trefor,

Or, to return the row (as you asked) rather than the address:

'==============
Sub Tester()
MsgBox Application.Caller
MsgBox ActiveSheet.Buttons(Application.Caller). _
TopLeftCell.Row
End Sub
'<<==============


---
Regards,
Norman



"Trefor" wrote in message
...
If I have a sheet with 20 buttons (1 on each row) and each button points
to
the same macro, is it possible for the macro to determine the Row number
(Or
possibly the Button Name)?

Based on the row, the macro will continue updating data on that Row.
--
--
Trefor