View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Loading two forms

You can use the workbook_Open event to show the first form and schedule the
second.

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

will give you an overview of events.

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

will show how to schedule a macro to run (to show the second userform)



is sample code for the first part:
http://www.j-walk.com/ss/excel/tips/tip39.htm

--
Regards,
Tom Ogilvy



"JR" wrote:

Hi all,

I need to load two forms in the same workbook at different times. The first
form will load upon opening the workbook (the form tells the customer that
the pivot tables are updating, please allow 30 seconds for the update).

The second form needs to load 35 seconds after the workbook opens (this form
tells the customer that the pivot table is updated).

Can someone please provide the code I need to accomplish this task?

Thanks you.