Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a userform that is using a multipage with 13-14 pages and on
each page there will be 5-6 controls (labels) that can be selected. Instead of writing an event procedure for 13-14x5-6 labels is it possible to write a generic procedure that will return which label was selected (double clicked) To clarify, if on multipage 1 I clicked label 3 I would like the Name of Label3 to be used in launching a new userform with Label3.name used as one of the variables on the new userform. If I click on multipage 12 label 63 i would like label63.name to be returned. My original thought was to look at MSForms.Controls but I'm having a hard time. I was trying to use userform_dblclick or multipage_dblclick however double clicking on a label (the behaviour i'm trying to capture) does not get captured. Any Ideas? Thanks in advance, mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you .DELETE a (sub-menu) Control that was clicked? | Excel Programming | |||
Return Control to Userform | Excel Programming | |||
Problem: Control Toolbox Control resizes when clicked | Excel Programming | |||
Return Index of Control Object Clicked! | Excel Programming | |||
Keep userform visible, but return control to calling routine | Excel Programming |