Originally Posted by
Kenneth Hobs
With Range("P26")
.Value = Val(cbESN)
.NumberFormat= "# ##0"
End With
Thank you. It worked like a charm on the one spreadsheet and the UserForm that I have there. I now tried a similar format on a different spreadsheet and it is not working. I keep getting a error message: Unable to set the NumberFormat property for the Range class
I actually wanted a different NumberFormat, but tried the exact same one that was working on the first sheet. I really don't know what I'm doing wrong.
With Range("D28")
.Value = Val(Me.tbNt)
.NumberFormat = "# ##0" ' Format I actually want "0.0_ " The format that I used on the other UserForm "# ##0_ " and it worked.
End With