• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

How do I format my Excel VBA MsgBox text ?

Dear Experts,

is it possible to format the text in a MsgBox object. For example:

1. Centre the text in the box.
2. Apply font attributes to the text.
3. Insert a small image file (such as a .png logo) inside the box

Thanks in advance
Toco
0
Tocogroup
Asked:
Tocogroup
2 Solutions
 
ProfessorJimJamCommented:
how can manipulate the msgbox easily with the free add-in for customising msgboxes  

to download free add-in refer to http://www.h3.dion.ne.jp/~sakatsu/ktMsgBox_Series_English.htm
0
 
Rob HensonFinance AnalystCommented:
You could also set up a User Form to include the necessary message text, option buttons and graphics.

Thanks
Rob H
0
 
TocogroupAuthor Commented:
Thanks for both useful suggestions. I will try both ideas. Have split the points.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now