AnsweredAssumed Answered

Get Command Button to execute two Actions in ProcessBook using VBA

Question asked by Mikeconnors on Jun 10, 2016
Latest reply on Jun 10, 2016 by Mikeconnors

Hi All,

 

I'm currently having a bit of trouble with this one. I have created a UserForm in ProcessBook which has a button on it. When that button is clicked the user gets taken to a different display. The issue I'm having is that once the new screen opens, the UserForm is still there. How do I get the button to take me to a new screen AND clear the UserForm?

 

This is what I have so far. Without the 'Unload Me' it works fine but as soon as i add it in, ProcessBook crashes

 

 

Private Sub CommandButton1_Click()

 

    strCurrentPath = Left(ThisDisplay.Path, (InStrRev(ThisDisplay.Path, "\")))

 

    strFileNameAndPath = strCurrentPath & "Eastern Ridge Server Deep Dive.PDI"

 

    Call Application.Displays.Open(strFileNameAndPath, True)

   

Unload Me

   

End Sub

 

 

Thanks,

 

Michael

Outcomes