Have to click the closed command button twice to close UserForm

[sspatriots]

Hi,

I've got a second UserForm called "Pleasewait" that pops up over my existing UserForm ("Job_Status_PM") while my code is updating changes to the worksheets and saving the file. However, using that "Pleasewait" UserForm forces me to select the Close command button on my main UserForm ("Job_Status_PM") twice. Is there a way to shift he focus back to the main UserForm called "Job_Status_PM" so that I don't have to hit the close button twice?


Thanks, SS

 

[sspatriots]

Just figured it out. I added the line below to the end of the command button code that updates my worksheets and saves the file after the temporary form called "Pleasewait" is unloaded. Wanted to put this up here in case it helps someone else and nobody waste any time looking into it. Thanks folks...SS

Job_Status_PM.cmdClose.SetFocus