Sum the listbox column

[jujuaurich]

Good afternoon,

I was needing some help with the attached spreadsheet.

As pictured below:
- Circled in purple is the filter for the data that appears in the listbox;
- Circled in red is the column that has to be summed;
- Circled in blue is where the sum value has to appear.

The total value must appear even without filter and after the filter is placed, the values that appear relative to the filter must be added.

Attachment 828825

Please Login or Register  to view this content.

TEST1.xlsm

[torachan]

give the attached a trial - hopefully date formats will be O.K.

[jujuaurich]

Hello, thank you very much for your help

I opened the file and when I execute the code I get the message


Could not set ColumnWidths property. Type Not matching.

[torachan]

It is probably the separators in the list widths property in the initialize event - your locale setting probably uses semi-colons as the separator character.
Simply replace all the commas between the each list width number with a semi-colon.