Does the variable source from outside of the form?
With Userform1.
.Label1.Caption = Format(myVar,"#,##0.00")
.Show
End With
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"mushy_peas " wrote in message
...
Hi Folks, me again
If i have a userform, how can display on it a varible, ie lets say a
running total.
Thnks
---
Message posted from http://www.ExcelForum.com/