Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button Name or Cell Reference
I have a sheet with 20 rows, at the end of each row is a button. If each
button calls the same macro, is there a way to know either which Button was pressed (e.g. Button Name = "Button 1", or which Row or Cell Reference the pressed Button was on? I need to get the row number to process other code based on the row the button was on. -- Trefor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button Name or Cell Reference
Hi Trefor,
See reponse to your later post --- Regards, Norman "Trefor" wrote in message ... I have a sheet with 20 rows, at the end of each row is a button. If each button calls the same macro, is there a way to know either which Button was pressed (e.g. Button Name = "Button 1", or which Row or Cell Reference the pressed Button was on? I need to get the row number to process other code based on the row the button was on. -- Trefor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I don't have the relative reference button . why? | Excel Discussion (Misc queries) | |||
Can I get Button name or Cell Reference | Excel Discussion (Misc queries) | |||
How to determine button reference | Setting up and Configuration of Excel | |||
RELATIVE REFERENCE BUTTON | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions |