Another one....right over the plate

[Roccofan]

I've created a simple dialog box and I want it to appear when the workbook is opened, how do I do this?
This message was edited by Roccofan on 2002-08-26 12:54

 

[lenze]

Place this in the ThisWorkBook Module

Private Sub Workbook_Open()
UserForm1.Show
End Sub
This message was edited by lenze on 2002-08-26 12:58

 

[Roccofan]

Lenze,

Thank you very much for all you help today. I have one last question:

When I open this workbook I get the following error message:

"System Error &80070057 (-2147024809. The parameter is incorrect.)"

If I press the "Help" button present on the dialog box the help message is that the system has detected an error...that's all it says. When I click "OK" the message goes away and the data in the workbook is fine. Any idea what might be causing this?

RF
This message was edited by Roccofan on 2002-08-26 13:09
This message was edited by Roccofan on 2002-08-26 13:10

 

[lenze]

I haven't a clue.

Sorry

 

[Ivan F Moala]

Whats is the code in your userform + the Loader code you use to Load this form ??
eg as Lenze has given ??