How To....

G

Glen Harvey

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
 
W

William

Hi Glen

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

--
XL2002
Regards

William

[email protected]

| 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
 
Top