Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox basics
Hi Guys
Please help. I am obviously failing to understand something very basic about MsgBox syntax. I have only previously used this function to give simple messages to the user, and provide a single (default) OK button: E.g. MsgBox "Your time has expired" I want to add more buttons in due course (Yes, No, etc) but, for now, was just trying to customise the title (caption) of the the message box: MsgBox ("Your time has expired",vbOKOnly,"Time expiry notification") produces a compile error ("expected: =") and I can't make sense of the Help associated. I am not including any Help/Context, so have left those options blank I have tried assigning the message and Title as strings Dim Msg As String Dim Title As String Msg = "Your time has expired" Title = "Time expiry notification" MsgBox (Msg, vbOKOnly, Title) but to no avail.. And MsgBox (Msg, vbOKOnly, Title, , ,) just produces another type of 'expected' compile error Thanks, Phil PS. Once I have sorted the syntax, I should be able to use 0 instead of vbOKOnly, 1 for vbOKCancel, etc. Right? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DSUM Basics | Excel Discussion (Misc queries) | |||
basics? | New Users to Excel | |||
VBA form basics | Excel Programming | |||
Excel VBA basics | Excel Programming | |||
Help with the basics. Starting out. | Excel Programming |