Simple formatting question

B

Billy B

I have a UserForm with a textbox and I want to take the input value, format
it so two decimal places show at all times. Below is the line of code I am
working with. If I input 100 into the textbox, the value in the cell shows as
100. It doesn't make any difference if it is currency with no $ or a number
with two decimal places.

ActiveCell.Value = Val(Format(Me.txtOrigPrice, "Standard"))

Thank you.
 
J

joel

When you put the data into the worksheet it is going to use the formating of
the cell in the worksheet. You need to also change the formating in the
activecell

ActiveCell.Value = Val(Format(Me.txtOrigPrice, "Standard"))
ActiveCell.NumberFormat = "0.00"
 
J

Jacob Skaria

Dear Billy

ActiveCell.Value = Format(Val(Me.txtOrigPrice)),"0.00")
OR
ActiveCell.Value = Worksheetfunction.Round(Val(Me.txtOrigPrice)),2)


If this post helps click Yes
 
Top