Auto Open
 

If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub

Auto Open
 

Hi Karen

MsgBox "To update list - Make changes to cell ""B3"" only"

Cheers
JulieD

"Karen" wrote in message
...
If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub

Auto Open
 

Hi Karen,

Try double quotes:

MsgBox "To update list - Make changes to cell ""B3"" only", _
vbOKOnly, "ATTENTION"


---
Regards,
Norman



"Karen" wrote in message
...
If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub

Auto Open
 

-----Original Message-----
Hi Karen

MsgBox "To update list - Make changes to cell ""B3"" only"

Cheers
JulieD

"Karen" wrote in
message
...
If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I
do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub



.
Thank you so much for your help - Is it possible to make
any of the text bold?

Thank you again

Auto Open
 

-----Original Message-----
Hi Karen,

Try double quotes:

MsgBox "To update list - Make changes to cell ""B3""
only", _
vbOKOnly, "ATTENTION"


---
Regards,
Norman



"Karen" wrote in
message
...
If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I
do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub



Thank you so much for your help.

Karen

Auto Open
 

Not in the msgbox. but you could build a small userform and format it anyway
you want.

then your auto_open sub looks more like:

sub auto_open()
userform1.show
end sub



Karen wrote:

-----Original Message-----
Hi Karen

MsgBox "To update list - Make changes to cell ""B3"" only"

Cheers
JulieD

"Karen" wrote in
message
...
If I use the following code when a worksheet opens, How
can I put the "B3" in quotes within the code. When I
do I
get an error.

Sub Auto_Open()
' AutoOpen Macro
MsgBox "To update list - Make changes to cell B3 only",
vbOKOnly, "ATTENTION"
End Sub



.
Thank you so much for your help - Is it possible to make
any of the text bold?

Thank you again

--

Dave Peterson