Formatting a string in a message box?

**RustyNail** · 05-18-2015, 01:30 PM

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:

Please Login or Register  to view this content.

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

**Norie** · 05-18-2015, 01:34 PM

Where are the valued for TIMER STATE, Status bit# etc coming from?

**RustyNail** · 05-18-2015, 01:51 PM

Originally Posted by Norie

Where are the valued for TIMER STATE, Status bit# etc coming from?

Well,at this point, this text is used for information only..... thus
informing the user that the timer had two status bits
which denotes as the timer being on or off.

So I just need to take the text and display it
as explained in the initial post....

thanks for replying

**Norie** · 05-18-2015, 01:57 PM

If you have 'Status bit name: TIMER STATE Status bit# : 0: Value :0: Timer off Value :1: Timer on' hard coded in the cell then I'm afraid I can't see how you can display it with line breaks in the message box.

Have you tried manually adding line breaks in the cell using ALT+ENTER?

**RustyNail** · 05-18-2015, 02:32 PM

Yes, if I enter the text manually in a cell and use "ALT"/"ENTER" every time I want to feed a new line, then this works.

However, different information is stored in that cell and therefore, VBA code has to do the initial storing to the cell.

In reality, in dependence of several factors, cell "1,16" or (1P) gets its contents like this:

Please Login or Register  to view this content.

then later, I need to display them in a message box like this:

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

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

By using the following code:

Please Login or Register  to view this content.

I thought perhaps that Excel would have some special characters we can introduce in the string upon creation so
that the message box would then interpret these as textual placement operations such as, tabbing, newline etc...

I was wondering is there a textual character that I can insert in the string that would correspond to "ALT"/ENTER"
which could instruct the message box to carry out a line feed?

OR ELSE.....

I may just have to get into complicated string manipulations ... which I really don't feel like it

Let me know what one really should do in a situation like this!!

Thanks for replying
Rn

**RustyNail** · 05-18-2015, 03:00 PM

Bof .... this seems to work!!!!!

Cells(1, 16).Value = "Status bit #0:" & vbNewLine & "TMR ON FLAG:" & vbNewLine & "Value :0: Timer off " & vbNewLine & " Value :1: Timer on"

Go figure....

Rn

**Norie** · 05-18-2015, 03:02 PM

If you had some sort of pattern or a delimiter in the string then you could possible do something but as far as I can see you don't.

**RustyNail** · 05-18-2015, 03:26 PM

Ha ha!

This didn't work after all because it heightens my cell by a lot ... don't know why but it does!!!!

"If you had some sort of pattern or a delimiter in the string then you could possible do something but as far as I can see you don't"

What do you mean ? Maybe I can

**Norie** · 05-18-2015, 03:29 PM

By a delimiter I mean a character that can be used to determine how to separate the long string into separate lines.

When I first looked at your post I thought that ':' might have been a candidate for that but unfortunately that won't work.

**RustyNail** · 05-18-2015, 04:15 PM

Originally Posted by Norie

By a delimiter I mean a character that can be used to determine how to separate the long string into separate lines.

When I first looked at your post I thought that ':' might have been a candidate for that but unfortunately that won't work.

Well, to be honest.... everything is manageable !
I can pick a character that I feel can be used as a delimiter....

How about the "|" character?

So what can we do now that we agreed on a delimited character?

thanks Norie!

**RustyNail** · 05-18-2015, 04:44 PM

Originally Posted by Norie

By a delimiter I mean a character that can be used to determine how to separate the long string into separate lines.

When I first looked at your post I thought that ':' might have been a candidate for that but unfortunately that won't work.

Well, to be honest.... everything is manageable !
I can pick a character that I feel can be used as a delimiter....

How about the "|" character?

So what can we do now that we agreed on a delimited character?

thanks Norie!

**skywriter** · 05-18-2015, 05:37 PM

Perhaps Norie was thinking of something like this.

**Norie** · 05-18-2015, 06:09 PM

I was actually thinking more along these lines.

Please Login or Register  to view this content.

**protonLeah** · 05-18-2015, 06:25 PM

deleted.....

**skywriter** · 05-18-2015, 06:25 PM

Originally Posted by Norie

I was actually thinking more along these lines.

Please Login or Register  to view this content.

I like that. Into the toolbox it goes.

Formatting a string in a message box?

LinkBack

Thread Tools

Rate This Thread

Display

Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Re: Formatting a string in a message box?

Thread Information

Users Browsing this Thread

Similar Threads

Formatting a Message Box

Formatting Specific String within a Text based on the formatting found in another cell

Adding formatting to a message box

Formatting a variable used in a message

Formatting Message Boxes

Bookmarks

Bookmarks

Posting Permissions