Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto open a workbook | Excel Discussion (Misc queries) | |||
Auto open a .xlt template | New Users to Excel | |||
Auto Open | Excel Discussion (Misc queries) | |||
Auto Open won't die or go away | Excel Programming | |||
Auto Open | Excel Programming |