UserForm show cell value with the current Date and Tme

Hi All,

Can you please help me out with my userform in the attached workbook? I am getting three problems in below situations:

1.) I have written below vba codes in the ThisWorkbook to show the userform automatically at the opening of the workbook:

Please Login or Register  to view this content.

Problem - the userform continuously shows, and doesn't hide itself after the wait time of 3 seconds. I have to manually close the userform. How can I show the userform only for the 3 seconds at the time of opening the workbook?

2.) I want to insert a section in the userform where the current date and current time automatically can display. Kindly see the attached for the userfrom.

3) How can a userform show/ reflect a defined cell's value, for example - How can I connect cell A1 of sheet1 to the userform, so the userform will show cell A1's value in it at the time of opening?

Thanks in advance!

For #2 and #3

Place this code in the vba code for the form. You'll notice I placed a third label on the form for the contents of A1.

Please Login or Register  to view this content.

For #1 trying to figure out the correct syntax.

This seems to work...

Form code

Please Login or Register  to view this content.

Standard Module

Please Login or Register  to view this content.

This trick is AWESOME MAN!! Working perfect!!

I just edited label sequence in your codes:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

....but now I've got one more question regarding the UserForm, what if I create another userform, which is UserForm2.
Then how can I make UserForm2 as a password protection for the worksheet3? so if someone puts the right password, then only the worksheet3 will be visible.

P.S. —› Do I need to start a new thread for it?

You might find this interesting. It doesn't have the password protection part, but that can be built in.

http://www.xl-logic.com/modules.php?...op=MostPopular

Userform Examples
(about 7th link down the page)

This is very interesting, thanks a world for inspiring me more!
I never thought that way of using the UserForms,,,, beauiful! I'm just trying to understand the codes, seem a bit higher than my programming level.

See this


PASSWORD FORM4.zip


In future though when one question has been answered, mark it solved. Then ask the next question in a new thread

Thanks for help!
Can anyone help me to tell about some good video tutorials abt making UserForms and using its Control features like ComboBox, ListBox making.
I am not so perfect in it.

Two places worth browsing...

http://www.fontstuff.com/excel/index.htm
http://www.contextures.com/

Thanks a world!

Now I will practice more.

Happy hunting