Msgbox text to contain string value

[mummbles74]

I am trying to create a message box that contains text and dim(ed) values in the text as below

Dim Holder As String
Holder = InputBox("Enter Holder")
Dim Updatedate As String
Updatedate = InputBox("Enter Date of day before last update")

I now want to us these values as the msgbox text like

msgbox("your holder is"&holder&"and your date is"&Updatedate&"thankyou")

but this seems not to work. Any idea what I am doing wrong
(this is not the actual text but will give me the info i need)

Thanks in advance for the help

 

[MrKowz]

What are you inputting, and what is your expected output?

 

[Jonmo1]

It's just nitpicky, it wants spaces between the variables and the & symbols

Try

MsgBox ("your holder is" & Holder & "and your date is" & Updatedate & "thankyou")

 

[machopicho]

Sub c()
Dim Holder As String
Holder = InputBox("Enter Holder")
Dim Updatedate As String
Updatedate = InputBox("Enter Date of day before last update")
MsgBox ("your holder is " & Holder & " and your date is " & Updatedate & " thank you")
End Sub

 

[mummbles74]

thanks just assumed (wrongly) that it would autocorrect the spacing issue.

Thanks again

 

[xenou]

I think it must fail to auto space the concatenation operator because it is also a type declaration character.

So this is valid VBA:

Sub Foo()
    MsgBox 100&
End Sub

But I don't recommend the use of type declaration characters as it can be a little confusing to those who don't use them and makes code less readable for such users. It's also inconsistent as some types don't have them (for instance, Byte or Object).