Hi Folks, me again

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

Thnk

--
Message posted from http://www.ExcelForum.com

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/

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

--
Message posted from http://www.ExcelForum.com

Hi

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

Userform1.Show vbModeless

HTH. Best wishes Harald

"mushy_peas " skrev i melding
...
Cheers got that working.
Another question

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


---
Message posted from http://www.ExcelForum.com/

that did the tricks, Thanks

--
Message posted from http://www.ExcelForum.com