Hello,
I have a userform with text boxes and I assign values from cells like below:
UserForm1.TextBox1.value = Sheets("Calculation").Range("A1").value
UserForm1.TextBox1.text = Sheets("Calculation").Range("A1").text

However when I change the code later to something like this:
UserForm1.TextBox1.value = Sheets("Calculation").Range("B1").value

Not only is the value updated/changed but the format is gone also.
How can I set the format/text only one time (on activate of userform for
example) so that I don't need to set the format everytime?

Thank you,
Ozgur