I would like to determine the Row,Column of a cell that is
underneath a button control when the user clicks on it...


Thanks,
Glen L. Harvey

Hi Glen

Sub test()
MsgBox _
Worksheets("Sheet1").Shapes("Button 1").BottomRightCell.Address
End Sub

--
XL2002
Regards

William



"Glen Harvey" wrote in message
...
| I would like to determine the Row,Column of a cell that is
| underneath a button control when the user clicks on it...
|
|
| Thanks,
| Glen L. Harvey