Inserting Form form Visual Basic...

[Guest]

I am quite the begginer here. After I create a form in the Excel's Visual
Basic, how do I insert that form into a worksheet, or have it auto-execute
when workbook is opened.
Thank you,
Thomas

 

[Norman Jones]

Hi Thomas,

In the ThisWorkbook module, try:

Sub Workbook_Open()

UserForm1.Show

End Sub

Where Userform1 is the name of your userform.

 

[Tom Ogilvy]

Use the workbook_Open event to show the form

Private Sub Workbook_Open()
Userform1.Show
End Sub

this would go in the ThisWorkbook Module

See Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

 

[Guest]

Thank you

Hi Thomas,

In the ThisWorkbook module, try:

Sub Workbook_Open()

UserForm1.Show

End Sub

Where Userform1 is the name of your userform.