|
Posted to microsoft.public.excel.programming
|
|
|
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
|