Label not really retrieving correct info

Posted by Patrick on April 16, 2001 6:51 AM

My label on my form is getting a cell value,however
it seems to want to move the decimal.....
the cells value is .0040
the label returns 4.000
is there some place in the properties of the label to
control this?.....I seem to be missing it if there is
thanks....please

Posted by Dave Hawley on April 16, 2001 6:55 AM

Hi Patrick

The Caption property of a Label should return a String. Try this:

Private Sub UserForm_Initialize()
Dim SlabelCaption As String

SlabelCaption = Sheets("Sheet1").Range("A1")
Label1.Caption = SlabelCaption

End Sub

Dave

OzGrid Business Applications

Posted by Patrick on April 16, 2001 7:32 AM

still returns the same...Dave this is my first
go at forms....incredibly....off to a good start.
can I send the file ......when you get a chance
to look over.....would be appreciated....only
this problem...you may see a few others...mine to
correct though:)
Patrick

Posted by Dave Hawley on April 16, 2001 4:35 PM

Hi Patrick

Sure, send it through! But are you certain the cell VALUE is 0004 and not really 4.00 formated to show 0004 ?

Dave

OzGrid Business Applications