Buttons
 

How do I identify a range of cells that a button is in when it is clicked?
Thanks

Buttons
 

Hi,

This will report cells covered by a button from the Forms toolbar.

Sub Button3_Click()

With ActiveSheet.Shapes(Application.Caller)
MsgBox "Button is over cells " & _
.TopLeftCell.Address & ":" & _
.BottomRightCell.Address
End With

End Sub

Cheers
Andy

ranswert wrote:
How do I identify a range of cells that a button is in when it is clicked?
Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Buttons
 

Thank You for the help

"Andy Pope" wrote:

Hi,

This will report cells covered by a button from the Forms toolbar.

Sub Button3_Click()

With ActiveSheet.Shapes(Application.Caller)
MsgBox "Button is over cells " & _
.TopLeftCell.Address & ":" & _
.BottomRightCell.Address
End With

End Sub

Cheers
Andy

ranswert wrote:
How do I identify a range of cells that a button is in when it is clicked?
Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info