message

  sms 16:18 03 Jul 07
Locked

I would like to create an opening message when an excel worksheet opens and then let it close after a time limit. Any ideas please

  VoG II 16:41 03 Jul 07

Create a Userform with a Label containing your message.

In the Visual Basic Editor, right click This Workbook and select View Code. Copy and paste in

Private Sub Workbook_Open()
UserForm1.Show vbModeless
Application.Wait (Now() + TimeValue("00:00:03"))
Unload UserForm1
End Sub

Save and close the workbook then reopen it to see your message.

"00:00:03" pauses for 3 seconds - change that and the name of the UserForm to suit.

  sms 09:49 04 Jul 07

Hi Vog

Copied your details into User Form as described, but nothing happened. Set up user form with Label.
Can you advis please

  VoG II 10:13 04 Jul 07

The code has to go in the ThisWorkbook code module. Also the file needs to be saved as an .xlsm file so that macros are enabled.

If you would like to send me a message via my yellow envelope I can send you an example file.

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now