Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Initializing Userform

I have a userform and i was wondering how to initialize it so it pops up when
the user loads the workbook..
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Initializing Userform

see Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

You would use the Workbook_Open event which would be placed in the
thisworkbook module.

by the way, this is showing the userform.

Private Sub workbook_Open()
userform1.show
End Sub

--
Regards,
Tom Ogilvy


"Szadkowski" wrote in message
...
I have a userform and i was wondering how to initialize it so it pops up

when
the user loads the workbook..



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 07 Initializing Folders reno Excel Discussion (Misc queries) 0 April 20th 07 07:32 PM
Need Help Initializing Excel Spreadsheet Program jb999 Excel Discussion (Misc queries) 0 November 7th 05 05:57 PM
Need Help Initializing Excel Spreadsheet Program jb999 Excel Discussion (Misc queries) 3 November 2nd 05 11:09 PM
Initializing static variables in VBA Adrian[_7_] Excel Programming 3 September 3rd 04 01:08 AM
Initializing User Forms Tom Ogilvy Excel Programming 3 June 28th 04 10:07 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"