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

Hi Thomas,

In the ThisWorkbook module, try:

Sub Workbook_Open()

UserForm1.Show

End Sub

Where Userform1 is the name of your userform.


---
Regards,
Norman



"thomas" wrote in message
...
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

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

--
Regards,
Tom Ogilvy

"thomas" wrote in message
...
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

Thank you

"Norman Jones" wrote:

Hi Thomas,

In the ThisWorkbook module, try:

Sub Workbook_Open()

UserForm1.Show

End Sub

Where Userform1 is the name of your userform.


---
Regards,
Norman



"thomas" wrote in message
...
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