MsgBox formatting

[Dave]

Hi

is it possible to format the text in a msgbox.. Ie, make some text appear
bold, or underlined?

Thanks in advance....

Dave

 

[Anne Troy]

Make a userform, Dave.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
www.Brainbench.com Word Test Developer 2000,2002,2003
********************************

 

[Dave]

Anne

Can I take it your answer "no, its not possible to format msgbox's text"? I
use userforms already, but wanted to know if its possible to format msgbox
text..

Thanks

 

[Tom Ogilvy]

It isn't possible with builtin arguments/settings.

 

[Guest]

Hi Dave

Not what you asked for but some formating is possible
See VBA help "format"

Private Sub CommandButton1_Click()

' Returns "5,459.40".
Message1 = Format(5459.4, "##,##0.00")

' Returns M36 in upper case
Message2 = Format(Range("M36"), ">")

MsgBox Message1
MsgBox Message2

End Sub

Good Luck

 

[Tom Ogilvy]

The OP asked:

Ie, make some text appear

bold, or underlined?

and format won't do that.

 

[Guest]

Tom:

That is why I prefaced my reply “ Not what you askedâ€


Good Luck
TK

 

[Tom Ogilvy]

Dave defined "format" to be:

some text appear

bold, or underlined?

then he asked for clarification that this was not possible with a msgbox

to which I responded:

"It isn't possible with builtin arguments/settings."

to which you responded:

"some formating is possible"

Whether you prefaced it or not, to me you are adding obfuscation to the
point of whether he can achieve his objective or not. So I attempted to
make it plain one more time. Not sure what your intent is since, as you
stated, your contribution doesn't answer [or pertain to] the question. It
you just wanted to provide some additional information, then post under
Dave's top level question, unless your intent is to contradict what I said.

 

[Guest]

I think you know my intentions were not to contradict or “obfuscateâ€
your point.
But, just to carry this ridicules augment one step further.

The first question

Is it possible to format text in a msgbox.. Ie, make some text appear
bold, or underlined?

Answer to part one yes : Answer to part two no

Just to clarify, my response was directed more to Dave’s second question
to Ann Troy who did not respond.

The second question

“Can I take it your answer “no, its not possible to format msgbox’s text�
I use userforms already, but wanted to know if its possible to format
msgbox textâ€

Answer: Some msgbox formatting is possible

TK

Dave defined "format" to be:

some text appear

bold, or underlined?

then he asked for clarification that this was not possible with a msgbox

to which I responded:

"It isn't possible with builtin arguments/settings."

to which you responded:

"some formating is possible"

Whether you prefaced it or not, to me you are adding obfuscation to the
point of whether he can achieve his objective or not. So I attempted to
make it plain one more time. Not sure what your intent is since, as you
stated, your contribution doesn't answer [or pertain to] the question. It
you just wanted to provide some additional information, then post under
Dave's top level question, unless your intent is to contradict what I said.

--
Regards,
Tom Ogilvy

Tom:

That is why I prefaced my reply " Not what you asked"


Good Luck
TK

 

[Tom Ogilvy]

Is it possible to format text in a msgbox.. Ie, make some text appear
bold, or underlined?

My apologies, I didn't realize you couldn't read the question. there is
only one part. That explains the confusion.

--
Regards,
Tom Ogilvy

I think you know my intentions were not to contradict or "obfuscate"
your point.
But, just to carry this ridicules augment one step further.

The first question

Is it possible to format text in a msgbox.. Ie, make some text appear
bold, or underlined?

Answer to part one yes : Answer to part two no

Just to clarify, my response was directed more to Dave's second question
to Ann Troy who did not respond.

The second question

"Can I take it your answer "no, its not possible to format msgbox's text"?
I use userforms already, but wanted to know if its possible to format
msgbox text"

Answer: Some msgbox formatting is possible

TK

Dave defined "format" to be:

some text appear

bold, or underlined?

then he asked for clarification that this was not possible with a msgbox

to which I responded:

"It isn't possible with builtin arguments/settings."

to which you responded:

"some formating is possible"

Whether you prefaced it or not, to me you are adding obfuscation to the
point of whether he can achieve his objective or not. So I attempted to
make it plain one more time. Not sure what your intent is since, as you
stated, your contribution doesn't answer [or pertain to] the question. It
you just wanted to provide some additional information, then post under
Dave's top level question, unless your intent is to contradict what I said.

--
Regards,
Tom Ogilvy

Tom:

That is why I prefaced my reply " Not what you asked"


Good Luck
TK



:

The OP asked:
Ie, make some text appear
bold, or underlined?

and format won't do that.

--
Regards,
Tom Ogilvy


Hi Dave

Not what you asked for but some formating is possible
See VBA help "format"

Private Sub CommandButton1_Click()

' Returns "5,459.40".
Message1 = Format(5459.4, "##,##0.00")

' Returns M36 in upper case
Message2 = Format(Range("M36"), ">")

MsgBox Message1
MsgBox Message2

End Sub

Good Luck


~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
www.Brainbench.com Word Test Developer 2000,2002,2003
********************************
Hi

is it possible to format the text in a msgbox.. Ie, make

some
text

appear
bold, or underlined?

Thanks in advance....

Dave

 

[koala]

now now children!!!!!!!!!!!

We are here to help and assist each other......... not puff our chest
and pander to our egos

 

[Guest]

Enough of your drivel, I’ll abdicate to the judiciousness of the readers.

TK

Is it possible to format text in a msgbox.. Ie, make some text appear
bold, or underlined?

My apologies, I didn't realize you couldn't read the question. there is
only one part. That explains the confusion.

--
Regards,
Tom Ogilvy

I think you know my intentions were not to contradict or "obfuscate"
your point.
But, just to carry this ridicules augment one step further.

The first question

Is it possible to format text in a msgbox.. Ie, make some text appear
bold, or underlined?

Answer to part one yes : Answer to part two no

Just to clarify, my response was directed more to Dave's second question
to Ann Troy who did not respond.

The second question

"Can I take it your answer "no, its not possible to format msgbox's text"?
I use userforms already, but wanted to know if its possible to format
msgbox text"

Answer: Some msgbox formatting is possible

TK

Dave defined "format" to be:

some text appear
bold, or underlined?

then he asked for clarification that this was not possible with a msgbox

to which I responded:

"It isn't possible with builtin arguments/settings."

to which you responded:

"some formating is possible"

Whether you prefaced it or not, to me you are adding obfuscation to the
point of whether he can achieve his objective or not. So I attempted to
make it plain one more time. Not sure what your intent is since, as you
stated, your contribution doesn't answer [or pertain to] the question. It
you just wanted to provide some additional information, then post under
Dave's top level question, unless your intent is to contradict what I said.

--
Regards,
Tom Ogilvy


Tom:

That is why I prefaced my reply " Not what you asked"


Good Luck
TK



:

The OP asked:
Ie, make some text appear
bold, or underlined?

and format won't do that.

--
Regards,
Tom Ogilvy


Hi Dave

Not what you asked for but some formating is possible
See VBA help "format"

Private Sub CommandButton1_Click()

' Returns "5,459.40".
Message1 = Format(5459.4, "##,##0.00")

' Returns M36 in upper case
Message2 = Format(Range("M36"), ">")

MsgBox Message1
MsgBox Message2

End Sub

Good Luck


~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
www.Brainbench.com Word Test Developer 2000,2002,2003
********************************
Hi

is it possible to format the text in a msgbox.. Ie, make some
text
appear
bold, or underlined?

Thanks in advance....

Dave