Valua of a cel as message in a MsgBox

[Reijer]

Hello Excellers,

How can i assign a valua (text) that is in cel B2 of an active sheet to a
part of the message of a MsgBox ?

Thanks for your attention,
Greetz Reijer.

 

[Don Guillett]

Sub textinmsgbox()
MsgBox "start of msg " & Range("k1") & " end of msg"

End Sub

 

[Gord Dibben]

Sub test()
dim myval as string
myval = Range("B2").Value 'or .Text
MsgBox "The value is " & myval
End Sub


Gord Dibben MS Excel MVP

 

[Reijer]

Thanks for your reaction, it helped me a lot.

Greetz Reijer

 

[Don Guillett]

glad to help