Hello,

A specific cell contains the following text:

"Status bit name: TIMER STATE Status bit# : 0: Value :0: Timer off Value :1: Timer on"

However, later I want to display it in a message box like this:

----------------------------------------------
Status bit name: TIMER STATE
Status bit# : 0:

Value :0: Timer off
Value :1: Timer on
----------------------------------------------

So I tried to store the string in the cell like this:

"Status bit name: TIMER STATE & vbNewline & Status bit# : 0: & vbNewine & Value :0: Timer off & vbNewline & Value :1: Timer on"

and call it like this:

Dim S as string 

S = Cells(1, 16).Value

Answer = MsgBox(S, vbOKOnly, "Block Status information")
But it displays like this:

Status bit name: TIMER STATE & vbNewline & Status bit# : 0: & vbNewine & Value :0: Timer off & vbNewline & Value :1: Timer on


Honestly, that's what I pretty much expected but it was worth a try

So is there an easy way to take the textual contents of a cell and format the text so that it appears in a message box as I explained above?

Thanks all for your help!
Rn