format caption
Hi,
I am using the following code to provide a sequential reference on a userform:
Label5.Caption = 0.0001 + Application.max(Sheets("Notes").Columns(1))
Problem is that if the reference should be 2004.0010, it is displayed on the
form as 2004.001.
Can anyone help me with the syntax to format the caption?
TIA
|