Buttons

  • Thread starter Thread starter ranswert
  • Start date Start date
R

ranswert

How do I identify a range of cells that a button is in when it is clicked?
Thanks
 
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
 
Thank You for the help

Andy Pope said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Write a button to run macro on *ANY* chart area clicked. 1
VBA set thick borders around non empty cells in range 0
Change event to add button 2
Dynamically Create and ID OptionButtons, then insert Row; Loop 2
Toggle Button help 3
Address of Selection Prior to Clicking on a Cell 1
How to identify Chart Source data as range? 3

Back
Top