Auto show a form
 

Whets the best way to have a form show on opening of a spreadsheet?

Auto show a form
 

In a module place the following.

Sub Auto_Open()
Sheets("Form-Home").activate ' The sheetname that the form is assigned to
Formname.show ' The name of the form
end sub
--
Pops Jackson


"Striker" wrote:

Whets the best way to have a form show on opening of a spreadsheet?

Auto show a form
 

One way:

Option Explicit
Sub Auto_Open()
userform1.show
end sub

This would go in a general module.

Striker wrote:

Whets the best way to have a form show on opening of a spreadsheet?

--

Dave Peterson