VBA Userform help

[jusfocuz]

I am working with userforms and i was wondering if it was possible to click a button on a userform, and program that button to show another userform for a certain amount of time and then show a another userform. So, one button click --> show two different userforms one at a time for certain time intervals..

thanks in advance

 

[Dashley]

jusfocuz

On the buttons click evet you could use a ouple of timers to contol how long each form was open or to open another..

 

[abaldwin]

Click event of button opens second user form

Second user form has timer control either on the form or declared in code. Its timer event would then shut unload itself and load the other form.

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[strongm]

VBA userforms don't have timer controls ....

 

[dglienna]

Make one the old fashioned way. Use a loop!



-David
2006 & 2007 Microsoft Most Valuable Professional (MVP)
2006 Dell Certified System Professional (CSP)

 

[johnwm]

jusfocuz

This potentially confusing set of answers is yet another demonstration of why you should post in the right forum. Please read faq222-2244 all the way through to see how to get the best from these forums. The VBA forum is forum707

When you have asked this question in the right forum please come back here and Red-Flag your original post asking for the thread to be deleted

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints