| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I open a Form in Excel XP
Hi Kevin
You can use a event to open the userform Read Chip Pearson's site about Events http://www.cpearson.com/excel/events.htm Copy this in the thisworkbook module Private Sub Workbook_Open() userform1.Show End Sub See also How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "Kevin" wrote in message ... How do I open a form using VBA in Excel XP? Help is of little help? I want to load the form on startup of the workbook. TIA Kevin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I open a Form in Excel XP
Thanks! That helps a lot!
-----Original Message----- Hi Kevin You can use a event to open the userform Read Chip Pearson's site about Events http://www.cpearson.com/excel/events.htm Copy this in the thisworkbook module Private Sub Workbook_Open() userform1.Show End Sub See also How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel http://support.microsoft.com/default.aspx?scid=kb;EN- US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "Kevin" wrote in message ... How do I open a form using VBA in Excel XP? Help is of little help? I want to load the form on startup of the workbook. TIA Kevin . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I open excel template form in a shared file using vista? | Excel Discussion (Misc queries) | |||
| Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
| Open Form Automatically in Excel File | New Users to Excel | |||
| Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming | |||
| Open an Acees Form from Excel | Excel Programming | |||
Linear Mode
