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

format caption
 

Label5.Caption = Format(0.0001 +
Application.max(Sheets("Notes").Columns(1)),""0000 .0000")


--

HTH

RP

"Newbie" wrote in message
...
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

format caption
 

Thanks Bob.

"Bob Phillips" wrote:

Label5.Caption = Format(0.0001 +
Application.max(Sheets("Notes").Columns(1)),""0000 .0000")


--

HTH

RP

"Newbie" wrote in message
...
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