Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto show a form
Whets the best way to have a form show on opening of a spreadsheet?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto show data but without using Auto Filter | Excel Discussion (Misc queries) | |||
How do I do? A personalized form, similar to Show data Form | Excel Programming | |||
Form.Show problem | Excel Programming | |||
How to show to a form in excel vba? | Excel Programming | |||
Help! Animated gif-image in form does not show animation when form loaded | Excel Programming |