View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH[_2_] RyanH[_2_] is offline
external usenet poster
 
Posts: 1
Default Identify which button called the userform

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