Message Box

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I'm using a message box in a macro and I'd like the text
(i.e. the "message") to be centered in the box. Right now
it is left justified.

Is that possible?

Thanks in advance.

Jerry
 
Jerry,
As per A98 and A2K...You can just add spaces in your message
box Prompt text to make it "look" like it's centered.
Prompt = "This is the First Line in the Prompt" & vbCrfLf
Prompt = Prompt & " The 2nd Line"
Prompt = Prompt & " This is the 3rd Line"
This prompt would look as though the text was centered. A
simple workaround, that doesn't take too much time.
(You have to lay out the message text anyway)
 
Back
Top