Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Format Macro Message Box

Is it possible to format message in Message Box, so that message or a word in Bold or different colors

Break message so that it appears on 2 line

thanks
Bob Leonar

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Format Macro Message Box

Hi Bob
you can't do this with the standard message box. You have to create you
own userform

--
Regards
Frank Kabel
Frankfurt, Germany

"rleonard" schrieb im Newsbeitrag
...
Is it possible to format message in Message Box, so that message or a

word in Bold or different colors?

Break message so that it appears on 2 lines

thanksl
Bob Leonard


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Format Macro Message Box

You can easily split the message to appear on multiple
lines, but you can't control bolds, etc. To make it
appear on 2 lines you can do this:

msgbox "hello" & chr(10) & "there"

Stuart


-----Original Message-----
Is it possible to format message in Message Box, so that

message or a word in Bold or different colors?

Break message so that it appears on 2 lines

thanksl
Bob Leonard

.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Format Macro Message Box

Frank
To create my own userform in a Macro, what would the code be in Macro with questio

If OK,press Ok; Oherwise press cancel

if ok is pressed will rum application_prin

Thank
Bob Leonard
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Message box date format macro help Aaron Excel Worksheet Functions 2 June 16th 09 08:16 AM
Message box date format macro help Aaron Excel Worksheet Functions 2 June 16th 09 07:17 AM
Format results in Message Box Jim G Excel Discussion (Misc queries) 3 February 28th 07 12:03 AM
#N/A message & Conditional format Ken Excel Discussion (Misc queries) 6 January 25th 07 06:34 PM
Number format in a message Lianna Excel Programming 1 July 18th 03 02:59 PM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"