VBA script to display a form

[Geoff Claydon via AdminLife]

Could someone please tell me what I need to do to display aninput form when I open a worksheet. I have created the formcalled "Taskform" in the forms section of the VBA editor andwhat I want if for that form to be the first thing that a usersees when they open the Worksheet.

Thanks

 

[Jason Morin]

Put this in a regular module:

Sub Autpen()
Load Taskform
Taskform.Show
End Sub

HTH
Jason
Atlanta, GA

-----Original Message-----
Could someone please tell me what I need to do to display

an input form when I open a worksheet. I have created the
form called "Taskform" in the forms section of the VBA
editor and what I want if for that form to be the first
thing that a user sees when they open the Worksheet.

 

[Frank Kabel]

Hi
put your code to open/show the userform in your workbook_open event.
See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag Could someone please tell me what I need to do to display an input form
when I open a worksheet. I have created the form called "Taskform" in
the forms section of the VBA editor and what I want if for that form to
be the first thing that a user sees when they open the Worksheet.

Thanks