View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default 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