Thanks,
I tried it but it gave me a error.
The cell contains a percent (22.9). In order for my textbox to show any value I have placed my code in the userform initialize event.
Textbox1.text = sheets("sheet 5").Range("J74")
As long as I keep that code the textbox shows the value 0.229, but I need for it to show 22.9. I have placed the above code in the textbox_change event but the textbox was blank when opened. If I try and write a format code in the textbox_change event it comes up blank.
Any other ideas?