Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 3 userforms (frmCC, frmEC, & frmPC) that have a particular button
Named "btnReveals". This button calls another userform named "frmReveals". How can I identify which of the 3 userforms (frmCC, frmEC, & frmPC) have called frmReveals? For example, if frmCC calls frmReveals, I want to disable some controls on frmReveals. If frmPC calls frmReveals, I want to disable a differenct set of controls. This is what I had in mind: ' frmReveals Private Sub UserForm_Initialize() ' disable contols on Reveals userform depending on which button calls it Select Case Application.Caller Case Is = "Button 178" ' frmCC button ' disable non applicable reveal controls Case Is = "Button 179" ' frmEC button ' disable non applicable reveal controls Case Is = "Button 180" ' frmPC button ' disable non applicable reveal controls End Sub Thanks for your help in Advance! -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Sub - Called from Userform | Excel Discussion (Misc queries) | |||
Retaining Values in Userform when called a second time | Excel Programming | |||
User Defined Function - Can we identify the cell it's called from | Excel Programming | |||
Passing a value from 1 userform to another when you dont know who called it. | Excel Programming | |||
Why does this code not create a button when called??? | Excel Programming |