Userform Auto_open

Posted by lucky on January 08, 2002 3:21 AM

I wish to have a Userform appear when a user opens an excel file. I have tried the following but does not work:

Public Sub Auto_open()
UserForm1.Show
End Sub

I also which to have a series of text boxes on the one userform and whatever the user types in these boxes is recorded on Sheet1.

Is this possible, or should I just use a number of input boxes?

Thanks again!

Posted by Dank on January 08, 2002 4:14 AM

Where have you placed the macro you list? It needs to be placed in a standard module. The alternative is to use a Workbook_Open event in the code module of the workbook in question.

If you need any more info please let me know,

Regards,
Daniel.

Posted by James on January 08, 2002 4:26 AM

To link a text box to a cell in a speadsheet trt this:

In the design mode, click on the textbox, then in the properties window select ControlSource. In this property window type in the cell reference where you want the users input to go. For example =Sheet1!A3

That should do the trick.

Regards
James

Posted by lucky on January 08, 2002 5:10 AM

Thanks fellas, all good!