summing data writen by a excel vba form

Hi FrankCF,

When you're writing the data to the worksheet from the Form, are you inserting the data as text values rather than numeric?

When you use =sum(a1:a10) on text values, even numbers as text, you'll get 0. If you used =a1+a2...+a10 it would actually return the correct number.

The best option would probably be to have your vba write the data as numeric to begin with, e.g.

Please Login or Register  to view this content.

ALSO: Make sure the cells you're writing to aren't already formatted as Text.

A TextBox by default enters Text. I would always use NumberFormat

Please Login or Register  to view this content.