Display a text box at startup
 

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.

Display a text box at startup
 

On Feb 25, 7:22*am, Eno wrote:
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

Display a text box at startup
 

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.

"CurlyDave" wrote:

On Feb 25, 7:22 am, Eno wrote:
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