Bold Font inside MsgBox

[Willmonbo]

I am using a message box that pulls in a variable, I would like the variable to be displayed in Bold, can anyone help.

Thanks.

 

[RoryA]

You can't do that with a message box. You'll need to create a userform and use a separate control for the bold part from the rest of the text.

 

[Willmonbo]

I am not sure how I would use a user form, the msg box that I have is triggered when i call a macro that deletes certain data in my data set, and this msg box helps me prevent accidental deletions, can I somehow use a user form in this scenario?

On a separate note, can you apply formatting to a text box in a user form, like i have a text box that I will use for numbers only, can i format it so it appears in a currency format?

 

[RoryA]

Yes, you can use the Format function when you load the text into the textbox (or other control).
You can use a userform anywhere you can use a messagebox, though to be honest this sounds like more effort than it's worth to me - I would probably just put the variable on a separate line.

 

[Willmonbo]

I hate admitting it, but I don't know how to put the variable in a separate line, your help truly is appreciated.

while I am still at it, my question with regard to formatting a text box entry, goes to a user form text box that the user types data into the text box and and the user form code then distributes the data onto the sheet, but i want to data to appear in a currency format while still in the text box when the user enters the data

 

[RoryA]

msgbox "some text:" & vbcrlf & variablename