MsgBox Help

[~Zodiac~]

hi

my code is this

MsgBox prompt:=Text2, Buttons:=vbOKOnly, Title:=Title2

both text and title are variables wich i declared in advance, they are filled with text

when i want to run this it gives me a
Runtime Error 13
Type Mismatch

in what way do i have to alter the msgbox in order to let it work properly?

(yes displaying that text in a msgbox is all i want)

Thanks in Advance

 

[texasalynn]

without seeing all your code can't tell why. But this works:

Sub box()
Text2 = "Hello"
Title2 = "Info"
MsgBox prompt:=Text2, Buttons:=vbOKOnly, Title:=Title2
End Sub

HTH
texasalynn

 

[Te4t0n]

This should do the trick:

msgbox (test2,,title2)

HTH

 

[texasalynn]

a piece of my code


Dim Text2 As String
Text2 = "Haal nu met MRS de Moves binnen, en sla deze op als X:\Departments_M_Z\TPD\METL\Teams\data\" + Jaar + "\moves\" + Maand + "\Selectie.xls"

...
'some events that work fine (never altering Text2)
...

Title2="ARC304"
MsgBox prompt:=Text2, Buttons:=vbOKOnly, Title:=Title2

could it be that my Text2 is to long? and if so what declaration should be used for this?

pls help me out

Thanks in Advance

Please continue your questions in the post and not in PM, that way others might have a chance to answer you.

What is happening? This works fine for me. Are you getting an error?

texasalynn