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?
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.
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