S
sam
Hi All, I want to display a '$' sign in excel sheet once user inputs the
'amount'. the cell in excel is populated through a userform. Here is my code
to format the textbox in userform:
Amount.Text = Format(Amount.Text, "$#,###.00")
I am getting the $ sign in the text box field, but once its populated in
excel sheet I dont see the $ sign, I just see 6,444.00
Here is my code to print the input in excel through the userform:
ws.Cells(10, 8).Value = Me.Amount.Value
Thanks in Advance
'amount'. the cell in excel is populated through a userform. Here is my code
to format the textbox in userform:
Amount.Text = Format(Amount.Text, "$#,###.00")
I am getting the $ sign in the text box field, but once its populated in
excel sheet I dont see the $ sign, I just see 6,444.00
Here is my code to print the input in excel through the userform:
ws.Cells(10, 8).Value = Me.Amount.Value
Thanks in Advance