How to apply number format to text box control?

[Kelvin Stott]

Hi,

I've created a simple user form which calculates and enters a default value into a text box control. It all works fine, but how can I display that value in a specific number/date format, according to the number or date format of a specific cell?

I tried this:

TextBox1.NumberFormat = MyCellRef.NumberFormat

But unlike cell ranges, the text box control does not have a numberformat property, so how can I do this?

Any help would be much appreciated, thanks.

 

[Kelvin Stott]

Thanks again.