Unserform with a varible

M

mushy_peas

Hi Folks, me again

If i have a userform, how can display on it a varible, ie lets say
running total.

Thnk
 
B

Bob Phillips

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)
 
M

mushy_peas

Cheers got that working.
Another question

The Userform is from another sheet, but is it possiblle to stil
navigate around a sheet whilst the form is still up
 
H

Harald Staff

Hi

Show it modeless -if you're on Excel2k or later that is:

Userform1.Show vbModeless

HTH. Best wishes Harald
 
Top