Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Excel 2003, and Visual Basic for Applications. (I've been using a
reference book written in 1994, but have looked online and through the VBA help material extensively.) I have managed to write code to place a custom menu on the Worksheets Menu Bar, add two popup controls, "Go To" and "Print", and add the names of the worksheets of the workbook to each as control buttons. But, I can't figure out how to return values from a control. I know I can use OnAction to run a procedure, but I want to know, for example, the Caption of the button that was clicked. (Just getting the index number of the clicked button would probably help, but then I'd have to figure out how to translate that index number into the caption. But, I would be happy to know how to get both the caption and the index, just for future reference. Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumif using Values, but returning text or values | Excel Discussion (Misc queries) | |||
Mactching Values & Returning Values | Excel Programming | |||
Sorting unique values and returning values from a formula | Excel Programming | |||
Returning Values | Excel Programming | |||
returning values | Excel Programming |