Private Sub UserForm_Initialize()
Label2.Caption = Worksheets("Data").Range("j20").Value
End Sub

I am using this to draw calculated data from my worksheet and past
into my UserForm. I set my work sheet cell J20 up to use whole number
only, but when my UserForm calls the data up it is still being tol
decimal values. Instead of 125.5 showing up in my user form I want t
see just 125 How can I do this please?

Also any suggested reading web sites for someone just wetting thei
feet in this

--
Baf
-----------------------------------------------------------------------
Bafa's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57362