Can text in ListBox and MsgBox be high lighted?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top