Display a text box at startup

E

Eno

In previous versions of Excel you used to be able to create a text box that
was displayed to users at start-up - I had thought that this was in
validation but can no longer find it - can anyone help.
 
C

CurlyDave

In previous versions of Excel you used to be able to create a text box that
was displayed to users at start-up - I had thought that this was in
validation but can no longer find it - can anyone help.

Was it a text box or an Input Box or MsgBox?
Do you just want a message to display when the workbook is opened?

This goes into the WorkBook Module

Private Sub Workbook_Open()
MsgBox "Good Day!"
End Sub
 
E

Eno

It was an advisory box, a little like the 'Read only recommended' that you
can have, it popped up before displaying the data in the file. There was no
coding required just a simple input from the standard tool bar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top