Simple formatting question
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. |
Simple formatting question
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" "Billy B" wrote: 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. |
Simple formatting question
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 --------------- Jacob Skaria "Billy B" wrote: 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. |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com