I have a userform set to run on the Workbook_Open event, as below:
With UserForm1
      .StartUpPosition = 0
      .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
      .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
      .Show
End With
The problem I am encountering is that the userform displays before the "Home" page of the workbook is displayed. I need the user to be able to see the data on that page before making a listbox selection from the userform. I considered placing it in a worksheet_activate event, but that also does not solve the problem, as it would then trigger the userform every time the user visits another sheet and then returns, which is not desirable.

I've tried both a worksheet.activate and an application.wait before the userform, to no avail.

Has anyone a suggestion on how to resolve this? I see lots of search results for a delay on unloading, but not on loading.