Message Box Problems + Excel 2000

[Tom59593]

Hi there. I am attempting to write a macro that displays the following message (the green text) (I have written it in the exact format that I want):

Your event has been submitted successfully!

Please take a moment to send an email to your administrator informing them of your submission. According to our records, you need to send an email to:

(EMAIL ADDY SPECIFIED IN CELL "R2" OF DATABASE)

Your administrator will review your submission and provide you with any further steps necessary.

THANK YOU!!!

Below I have posted the vb Code that I have thus far, but I keep getting Unexpected seperator errors at random words throughout the message. If someone could repost the code I would need to get this to work properly, that would be extremely helpful.

THANK YOU!!!

I apologize for the having to side-scroll in my code...I thought that it might have had something to do with my message spanning multiple lines in the vb Editor, so this is what I tried....unfortunately this didn't fix it either.

'Display message box to user confirming submission and requesting email to be sent
MsgBox ("Your event has been submitted successfully!" & vbNewLine & "Please take a moment to send an email to your administrator informing them of your submission. According to our records, you need to send an email to:" _
& vbNewLine & vbNewLine & Worksheets("Database").Range("R2").Value & vbNewLine & vbNewLine "Your administrator will review your submission and provide you with any further steps necessary." _
& vbNewLine & vbNewLine & "THANK YOU!!!")

 

[Norie]

Why not try constructing the message like this?

Dim strMsg As String
strMsg = "Your event has been submitted successfully!" & vbNewLine
strMsg = strMsg & "Please take a moment to send an email to your administrator informing them of your submission. According to our records, you need to send an email to:"
strMsg = strMsg & vbNewLine & vbNewLine & Worksheets("Database").Range("R2").Value & vbNewLine & vbNewLine
strMsg = strMsg & "Your administrator will review your submission and provide you with any further steps necessary." & vbNewLine & vbNewLine & "THANK YOU!!!"
MsgBox strMsg

By the way the original code is only missing a single &.

...& vbNewLine & "Your administrator ...

 

[Tom59593]

haha...wow.

I thought about doing it the other way you proposed, but I had it this way first and I just kept going with it

Anyways, thank you for the quick fix...haha.