98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » MsgBox
MsgBox
Resolved · Low Priority · Version 2007
Fri 5 Feb 2010, 15:42Delegate 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:11Trainer 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:36Delegate Bryan said...
RE: MsgBox
Thanks Stephen, I shall await your reply.
Wed 17 Feb 2010, 10:43Trainer 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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Applying and removing border from cell in Excel 2010Did you know the shortcut key for applying and removing the outline border for a cell? |
