| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Buttons
How do I identify a range of cells that a button is in when it is clicked?
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Buttons/Radio Buttons | New Users to Excel | |||
| Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
| have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
| Replacing macro buttons with a new set of buttons | Excel Programming | |||
| Control Buttons vs. Command Buttons | Excel Programming | |||
Hybrid Mode
