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