Excel 97 VBA form focus

[StevePB]

I have a custom application that runs from an Excel template, which is launched from a short cut and set to run minimized.

On start up, a form is launched to get an i.d. number from the user. "OK" on this, unloads it and launches the getOpenFilename window, with a path based on the i.d.

Once a file has been chosen, it is opened and data from the file is displayed in another form.

The problem is that this last form appears, but does not receive the focus. How can I make sure this form gets the focus after it is displayed ?

 

[ide]

for example:
Set that form to a pop-up and modal form

 

[StevePB]

Thanks for your response ide.

I am loading the form with the formName.Show method. In the VBA help it says "a user form is always modal" - so I assume it must already be modal.

 

[StevePB]

In case anyone is interested, I figured out what was causing the problem. I wanted Excel to be minimized while the form was being used, so in the click event of the button that loaded the second form I put:

[tt]Application.WindowState = xlMinimized[/tt]

- when I took this out, the form got the focus.