| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return caption of unknown button into a cell
Is there a way to capture the caption information of a CommandButton that
was just pressed without knowing the name of the CommandButtonand? I'd like to be able to press a command button (any CommandButton) and have the caption from that button displayed in, say AA1? Is there some sort of "ActiveCommandButton" code? Range("AA1").Value= CaptionOfButtonJustPressed Is this possible? Paul -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unknown error in function, and how to return value? | Excel Worksheet Functions | |||
| How to set up caption on a button at startup? | Excel Programming | |||
| return .caption text of worksheet control | Excel Programming | |||
| Place the caption of a toggle button into a cell | Excel Worksheet Functions | |||
| Caption of a button | Excel Programming | |||
Threaded Mode
