Unserform with a varible

[mushy_peas]

Hi Folks, me again

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

Thnk

 

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

 

[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

 

[Harald Staff]

Hi

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

Userform1.Show vbModeless

HTH. Best wishes Harald

 

[mushy_peas]

that did the tricks, Thanks