I have formated a text box to display dates with the following line in the textbox code:
Private Sub TextBox1_Change()
TextBox1.Text = Format(Range("$bi$4"), "dd-mmm-yy")
End Sub
It works fine until I print preview or print the page and then it goes back to date code and isnt formatted anymore.
Anyone know how I can avoid this happening?
TIA
Dan.
Private Sub TextBox1_Change()
TextBox1.Text = Format(Range("$bi$4"), "dd-mmm-yy")
End Sub
It works fine until I print preview or print the page and then it goes back to date code and isnt formatted anymore.
Anyone know how I can avoid this happening?
TIA
Dan.