How To....
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 |
How To....
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 |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com