PDA

View Full Version : [SOLVED] Message Box



Ismael
08-25-2005, 03:29 AM
Hi,

I have a macro that in the end return's a message box.

the code is:

Dim Msg1 As String
Msg1 = "A probabilidade"
MsgBox Msg1

But I want to return the text plus the value on cell I3 how can I do that?

Best regards,

Ismael

Marcster
08-25-2005, 04:06 AM
Hi Ismael,

Try this:


Dim Msg1 As String
Msg1 = "A probabilidade " & Range("I3").Value
MsgBox Msg1

Hope this helps,

Marcster.

Ismael
08-25-2005, 04:16 AM
Hi Marcster,

It works, thanks for the help.

Best regards,

Ismael

johnske
08-25-2005, 04:16 AM
you can also do this in one line
MsgBox "A probabilidade " & Range("I3")