Font size in msg box

I have created a "splash screen" msg box, i have made the title in this msg box, but within this message box there is 2 sections one for the week and one for the month, whihc shows sales, qtys and profit, basically its a summary of the report they are about to view.

What i want to do is have something a little like this within the msg box

Week

Sales £10,000
Qty 6,000
Profit £2,200

Month

Sales £50,000
Qty 21,000
Profit £9,400

below is what i have and i dont know how to change the numbers to accomodate the commas or change the sub heading to bold

Week

Sales £10000
Qty 6000
Profit £2200

Month

Sales £50000
Qty 21000
Profit £9400

Does anyone know if this is possible within my code to create? My code is currently......

Please Login or Register  to view this content.

I'm afraid not, you'll need to use a userform

Ah I was afraid this was the answer :-(

I understand I can put labels in the userform and then alter the font and size, but I couldn't get my formulas to work, which is why I used the msg box, using the code above would not work in the userform

Thanks for your reply

Dan

Sure they would Post your code for the userform with your formulas

Hi

Ok this works but only when i enter through the text boxes in the userform, i have tried the code in enter, beforeupdate and afterupdate, and it doesnt automatically show when the userform opens.

What should i be using after textbox1_????

I dont want to make the user have to enter through i just want it to pop up as a message when the workbook opens, which it does, and then dissapear when they click ok, which it does, but the text doesnt display unless they click into the text box?

Where did the textbox come from?

in the user form i used a label to get my sub heading (week)

then added a text box to get put the code in? is this the wrong approach?

Sorry, i put the code into userform_initialise wasnt thinking about it earlier :-)

Thanks for your help works perfectly now!

Dan