Make a sum of listbox entries in a userform texbox

[dotchieJack]

hallo everybody,
I am new to this forum and my native language in not Englisch.
I have a listbox that is populated with numbers and text from colom D in a worksheet.
I am trying to sum the numbers and displaying them in a textbox
Hope somebody can help
Uploading an example seems to fail
Thanks

 

[Marc L]

Hi !

Without a sample workbook and easier for a beginner :
just use SUM formula within a cell !
You can also use same formula with VBA Evaluate method (see VBA help) …
​

 

[dotchieJack]

Hoi Marc
Thank you for your quick response, but the problem is the entries are never the same, if there are 20 entries the sum should be on cell 21 or with 10 entries on cell 11.
So I was thinking to add a listbox to the userform make a sum of the entries and give the result in a textbox
Can you explain me to upload an example, when a push upload file the file can not be choosen, it is an xlsm file 53 kb
Thanks

 

[Deepak]

dotchieJack

Send the file to me : imdkbj at outlook dot com

& i will upload the same here!

 

[dotchieJack]

Hoi Deepak
Is send it , thank you for your answer

 

[dotchieJack]

I send an example file,with what i want as result
Thank you in advance

 

[Deepak]

file!