Thanks Bob - your help is much appreciated.

Paul

"Bob Phillips" wrote:

> 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
>
>
> --
> HTH
>
> Bob Phillips
>
> "webster" <webster@discussions.microsoft.com> wrote in message
> news:70A65AF6-9C08-435D-84EB-7411FF97C4A1@microsoft.com...
> > 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" <webster@discussions.microsoft.com> skrev i melding
> > > news:9FD7845F-0D8C-4B3C-B0F2-1F273C4D4789@microsoft.com...
> > > > 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
> > >
> > >
> > >
>
>
>