Message Box

[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

 

[Al Camp]

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)