Userform TextBox Problem... formatting code clears data instead of formatting

Friends,

Please Login or Register  to view this content.

I don't understand what the problem is... Without the second line, my text box has a value but with a million decimal places. Butwith the second line, the textbox is just blank...

Any suggestions?

Many Thanks,

-Mike

You need to include the Range("N41"):

Please Login or Register  to view this content.

Otherwise it interprets Value as a variable with nothing assigned to it.

Wallyeye,

Thanks so much that worked great!

One other question... I have a userform that accepts the lengths of three sides of an oblique triangle and calculates the area using Heron's formula. So if I have the user entering values in, say, TextBox1, TextBox2, and TextBox3 then AreaBox has the calculated area. What is the syntax to have AreaBox formatted to three decimal places?

Thanks!

You would just use:

Please Login or Register  to view this content.

Where dblResult is the result of your calculation.

Awesome! Thanks!

My problem was that i was not storing the result as a variable... So AreaBox.Value = TextBox.Value * TextBox2.Value

But now Area = TextBox.Value * TextBox2.Value and then formatting.

Thanks Again!