Custom User Form At Startup

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

I want a Userform to be displayed for only two seconds on opening of a
specific workbook!

How 2 achieve the same?
 
hi
you could put a sub in the workbook open event to display the form then use
the application.ontime event to call a sub that closes the form.
look up application.ontime in vb help and see this site for more details.
http://www.cpearson.com/excel/ontime.htm

regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Close form automatically upon opening workbook 2
how to reshow userform after following a link 1
VBA Codes to Control Flow Among Multiple Userforms 1
need help with using VBA to access a second spreadsheet 2
Disabling certain keys on keyboard 2
Is this possible? 4
Creating a lookup in a userform 4

Back
Top