Hello everybody
I have a userform .. I want the userform to appear automatically after a period of time after last edit.
Say I entered a value in C5 and pressed Enter key . I want the userform to appear after 15 seconds if I didn't do anything else in the workbook.
It may be called as a screen saver for excel
Hey, that's a pretty cool idea. I made this on a specific worksheet. It could be targeted for specific cells if you'd like.
Please Login or Register to view this content.
Last edited by daffodil11; 01-02-2015 at 07:54 PM. Reason: camel spiders
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Edited code:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
Put this code in sheet module :
Put this code in normal module :Please Login or Register to view this content.
RegardsPlease Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thanks a lot everybody
Mr. Karedog ..Can you make the code for userform and on the userform a textbox to type a password to let the user open the WB if he is authorized??
Hi,
Please look at my attached file, maybe this is what you expected.
Regards
Wonderful Mr. karedog
Your attachment is a masterpiece
Thank you very much
You are welcome, thanks a lot.
Regards
The downside being that this routine will block access to any and all workbooks in the same instance of Excel.
As soon as you enter data into the worksheet, the routine will be active ... and will fire even if you are working in another workbook.
Regards, TMS
Actually that could be expected or unexpected behaviour, depending of the user's will.Originally Posted by TMS
In case if the "screensaver" should be pop up only on the workbook it is stored, then a single line of code will fix it.
Regards
It was not a criticism, just an observation based on the solution provided.
Regards, TMS
Sure. I myself didn't take it as a criticism, but I provided another code in case the expected behaviour is as you stated (password userform should only pop ups for the launcher workbook, not for all the workbooks). In fact, this is a valuable input in case OP is not think about this.
Regards
These solutions are awesome.
Many thanks for the compliment, I really appreciate it.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks