Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » MsgBox

MsgBox

ResolvedVersion 2007

Fri 5 Feb 2010, 15:42 Delegate Bryan said...

Bryan has attended:
Excel VBA Intro Intermediate course

MsgBox

How can you center the display text on a msgbox

Wed 10 Feb 2010, 09:11 Trainer Stephen said...

RE: MsgBox

Hi Bryan

Thanks for your question

I have carried out an initial study of this problem and can find no simple solution. I am however sure that I have resolved this issue before, I will therefore make further studies and will respond definitively within the next few days

Regards

Stephen

Mon 15 Feb 2010, 16:36 Delegate Bryan said...

RE: MsgBox

Thanks Stephen, I shall await your reply.

Wed 17 Feb 2010, 10:43 Trainer Stephen said...

RE: MsgBox

Hi Bryan

Thanks for your patience

I'm afraid I can find no way to centre the text in the message box in VBA. All the sources I have checked suggest that it is impossible. I will continue looking into it and if I find anything I will follow up.

One possbility would be to add some blank spaces either side of the message. This is a bit cluncky but should work

Regards

Stephen

Wed 17 Feb 2010, 12:10 Delegate Bryan said...

RE: MsgBox

Many thanks Stephen, ill pad it out as you suggested.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

MsgBox

MsgBox

RE: MsgBox

RE: MsgBox

RE: MsgBox

RE: MsgBox

Excel articles

Excel tip:

Quick Absolute Cell References