How to display value in MsgBox

[Dheepak]

Hi,

I need the message box to display the content "Date 14/2/2105 has been selected". I have used the below code and used LDDate function to get the date.

Code:
MsgBox ( "Date" &LDDate1.DateString &"has been selected",vbOKOnly )

I'm getting the error notification stating "Complier Error: Expected:="

Someone please clarify the arrangements of data in msgbox

Regards,
Dheepak

 

[Rick Rothstein]

Hi,

I need the message box to display the content "Date 14/2/2105 has been selected". I have used the below code and used LDDate function to get the date.

Code:
MsgBox ( "Date" &LDDate1.DateString &"has been selected",vbOKOnly )

I'm getting the error notification stating "Complier Error: Expected:="

Remove the parentheses as they are not required by syntax... you can included parentheses that are not required by syntax only if what they enclose is a single argument.

 

[JoeMo]

Maybe:

MsgBox "Date " & Date & " has been selected", vbOKOnly

 

[AkaTrouble]

maybe this

MsgBox ("Date" & LDDate1.DateString & "has been selected"), vbOKOnly

edit

now i feel silly having looked at above replies

 

[Dheepak]

Thanks a lot Rick, Joe and Aka..

Best Regards,
Dheepak