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


"Harald Staff" wrote:

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

"webster" skrev i melding
...
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