How do I format the text in a message box?

The code below builds a message string that is then feed to a message box if it contains information on an error. The message string is a dynamic list of units and the number of missing months of data each has in a SQL based data download. Everything works except the column of the number of missing months of data does not line up. I suspect there is nothing wrong with my logic, I just need to switch the text in the message box to a non-proportionally spaced font or use some other technique to get it to line up. I'm brain dead at this point. Help!

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Added this time only

I don't think that you can format the text in a message box,maybe design a userform

You can change it in Control Panel to a fixed-pitch font, but it will effect other applications as well.

I agree with Roy -- make a simple userform.