| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show userform at spreadsheet open
How do you make a userform open when you open a spreadsheet?
Can anyone help? Thankyou, Roger [excel2003] |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show userform at spreadsheet open
hi
sheet or file? sheet..... Private Sub Worksheet_Activate() Load userform1 userform1.Show 0 End Sub lookup modal and modaless forms in vb help. file.... Private Sub Workbook_Open() Load userform1 userform1.Show 0 End Sub also see this site.... http://www.mvps.org/dmcritchie/excel/getstarted.htm regards FSt1 "Roger on Excel" wrote: How do you make a userform open when you open a spreadsheet? Can anyone help? Thankyou, Roger [excel2003] |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show userform at spreadsheet open
You could also right click on the tab you want the userform to open on and
type the NameOfYourForm.show. Put this on an on activate event. "Roger on Excel" wrote: How do you make a userform open when you open a spreadsheet? Can anyone help? Thankyou, Roger [excel2003] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| zeros show as dashes in spreadsheet, want to show 0. | Excel Discussion (Misc queries) | |||
| How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
| one column of cells show ####. Values show when I open it. Help | Excel Discussion (Misc queries) | |||
| show a userform | Excel Programming | |||
| How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming | |||
Hybrid Mode
