Dialog boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have a dialog box pop up when I open an excel workbook. I just
want it to say something like 'enter name in cell A6" and then have an "OK"
button that closes the pop up.

Any assistance would be appreciated
 
Hi

Open the VB editor (Alt F11 or similar).
Menu Insert > Module.
Paste this into the module:

Sub Auto_open()
MsgBox "enter name in cell A6", vbOKOnly, _
"Any assistance would be appreciated"
Range("A6").Select
End Sub

Save, close, reopen.

HTH. Best wishes Harald
 
Thanks Harald it works a treat.

Is it possible to have a number of lines in the msgbox such as
1. Enter name in A6
2. Enter D.O.B in A7
3. Enter Gender in A8

Paul
 
Sub Auto_open()
MsgBox "Enter name in A6" & vbNewLine & _
"Enter D.O.B in A7" & vbNewLine & _
"Enter Gender in A8", & _
vbOKOnly, "Any assistance would be appreciated"
Range("A6").Select
End Sub
 
Back
Top