Inserting Form form Visual Basic...

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>