format caption

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Label5.Caption = Format(0.0001 +
Application.max(Sheets("Notes").Columns(1)),""0000.0000")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DTPicker Date format 7
How to enumerate buttons on user form 2
button name scope and Caption 2
Userforms - automating the naming of frame and page tab captions 3
automation error 0
Set Userform label text if form is not loaded??? 3
Loading UserForm Controls (with a twist!) 5
changing activesheet shapes label caption 1

Back
Top