Compile error: Variable not defined

[Ken Puls]

Public SumXCollection As Collection is the declaration
and
Set SumXCollection = New Collection is the definition

and i need the both, in order to use my SumX collection, correct?

Yeppers. The first creates an (empty) global variable to hold your collection. The second actually initializes it.