Message Box Reference Cell Text

[Pinaceous]

Good Day,

I wanted to use a message box to reference a cell text.

For example,

 MsgBox "Created! & Worksheets(1).Range("A27").Text &"

How do I use improvise this code to accept the text in Worksheet(1).Range("A27")?

Thank you!

Pinaceous

 

[Gokhan Aycan]

You misplaced the closing double quote.

MsgBox "Created! " & Worksheets(1).Range("A27").Text

Edit: Inserted a space after "Created!" for readability.

 

[Pinaceous]

Thanks Gokhan Aycan!

How about this version of the same question?

 MsgBox "Created! & Worksheets(1).Range("A27").Text &", vbInformation, " ProtectUpdate."

Anyway to make this one work?

 

[Gokhan Aycan]

You are putting the double quote at the wrong place. Otherwise that will work, yes.