Display a text box at startup

  • Thread starter Thread starter Eno
  • Start date Start date
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.
 
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
 
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.
 
Back
Top