Dialog boxes

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

"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

Sub Auto_Open()
msgbox "Enter name in cell A6"
End Sub


--
Message posted via http://www.officekb.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
>
>
>

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
> >
> >
> >

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
> > >
> > >
> > >
>
>
>