Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
smart button
can a button know what cell it is located? I realize that a button can be
shaped and placed anywhere. Perhaps its location can be inferred by its attributes (coordinates)? If so, how does one fetch these attributes? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
smart button
Look at the TopLeftCell and BottomRightCell properties of the button.
-- Vasant "Big Al" wrote in message ... can a button know what cell it is located? I realize that a button can be shaped and placed anywhere. Perhaps its location can be inferred by its attributes (coordinates)? If so, how does one fetch these attributes? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
smart button
Hi Al
Assuming you have a button called "MyButton" on Sheet1 then Sub test() With Sheets("Sheet1") MsgBox .Buttons("MyButton").TopLeftCell.Address MsgBox .Buttons("MyButton").BottomRightCell.Address End With End Sub -- XL2003 Regards William "Big Al" wrote in message ... can a button know what cell it is located? I realize that a button can be shaped and placed anywhere. Perhaps its location can be inferred by its attributes (coordinates)? If so, how does one fetch these attributes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How smart is excel? | Excel Discussion (Misc queries) | |||
Invest smart | Charts and Charting in Excel | |||
Invest smart | Charts and Charting in Excel | |||
Smart tags | Excel Discussion (Misc queries) | |||
Smart subtotals | Excel Worksheet Functions |