Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

Can text in ListBox and MsgBox be high lighted?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pank - 23 Apr 2007 10:34 GMT
During the execution of a macro I use ListBox and MsgBox. Is it possible to
have certain words/text highlighted in Bold and/or Italics?

If I have the following text that is displayed in a ListBox:-

“The sheet that needs the data to be extracted should be called MASTER DATA.”

What I would like is the last two words (i.e. MASTER DATA) to be in bold and
Italic and if possible in font Verdana and size 20.

Additionally if I have a MsgBox that displays the following text:-

"Continuing with Extract. Please select OK"

What I would like is the last three words (i.e. Please select OK) to be in
bold and if possible in font Airal and size 18.
JLatham - 23 Apr 2007 11:36 GMT
The features you desire for those objects don't exist.  Sorry, but today the
answer is no.

> During the execution of a macro I use ListBox and MsgBox. Is it possible to
> have certain words/text highlighted in Bold and/or Italics?
[quoted text clipped - 12 lines]
> What I would like is the last three words (i.e. Please select OK) to be in
> bold and if possible in font Airal and size 18.
Pank - 23 Apr 2007 12:04 GMT
Thank you for your response.

> The features you desire for those objects don't exist.  Sorry, but today the
> answer is no.
[quoted text clipped - 15 lines]
> > What I would like is the last three words (i.e. Please select OK) to be in
> > bold and if possible in font Airal and size 18.
JLatham - 24 Apr 2007 00:16 GMT
I wish it had been better news.  I hate being the bearer of bad news.

There is not much you can do about the ListBox part of your request, but you
might consider this for the MsgBox part:
Create a UserForm with a picture object on it to present the message.  
You'll have to do some extra work to create the UserForm and to create the
picture to place on it, but it is an option.

If you have a screen capture program such as Irfanview (free) or SnagIt
(outstanding product, not free) [you can also do a search for a program
called PrintKey - another good one, and there are still copies of the last
free version available for download in a few places] you could use another
program such as Word to create a text message that looks just like you want,
take a 'screen shot' of it and place the picture on the userForm along with
an "OK" button that simply unloads the form and continues processing.  

All of the screen capture programs I mentioned have the ability to just
capture a rectangular area from the screen, so you could capture the text,
save it as a graphic file and put that into an image control on the UserForm
to get your message across.

> Thank you for your response.
>
[quoted text clipped - 17 lines]
> > > What I would like is the last three words (i.e. Please select OK) to be in
> > > bold and if possible in font Airal and size 18.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.