ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom User Form At Startup (https://www.excelbanter.com/excel-discussion-misc-queries/186630-custom-user-form-startup.html)

FARAZ QURESHI

Custom User Form At Startup
 
I want a Userform to be displayed for only two seconds on opening of a
specific workbook!

How 2 achieve the same?

--

Best Regards,
FARAZ A. QURESHI

FSt1

Custom User Form At Startup
 
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

"FARAZ QURESHI" wrote:

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

How 2 achieve the same?

--

Best Regards,
FARAZ A. QURESHI



All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com