I am assuming you want to use one of two (or more) strings in the message box
depening on the outcome of an IF test.

dim strMessage as string

IF <test
strMessage = "Hello World"
Else
strMessage = "Goodbye World"
End IF

msgbox strMessage

Is this what you're looking for?


"jt46" wrote:


Thanks for all your help.

Question: Using msgbox, is anyway you can add in the "IF" statements &
could you give me a little example? Thanks in advance.

John


--
jt46
------------------------------------------------------------------------
jt46's Profile: http://www.excelforum.com/member.php...o&userid=15154
View this thread: http://www.excelforum.com/showthread...hreadid=267861