Help Populating ListBox

[Scott M]

I would like to populate a list Box with the sum of the values entered in the textboxes on a user form without putting any data in a worksheet is this possible?
For example the user brings up the user form and enters 2 in textBox1 and 2 in textBox2 then the list box would show 4

 

[Scott M]

Thanks Vladimir for your help the code works just fine but it is rounding the 4th digit up witch I am sure that is what it should do. However I need the digits just cut off at 4 digits for example. The result that I was getting was 16.859375 Now I am getting 16.8594. I need it to be 16.8593.Is there any way to make this code do that?

 

[Norie]

Scott

I thought you had a problem with the code or result.

If you don't want the value 'rounded' when it's formatted then round it before you format it.

Something like this perhaps.

LstBxResult.AddItem Format(Application.RoundDown(x, 4), "#0.0000")

 

[Scott M]

Thanks Norie that is wonderful sorry about the confusion