Creating a class module with my VBA code

[potterotter]

Hi all,

I'm fairly new to class modules. I have the current code and need to create a class module of it. How can I do so? Thanks!

Please Login or Register  to view this content.

[mikerickson]

Class modules are for creating custom objects.
What object are you trying to create?

[potterotter]

Class modules are for creating custom objects.
What object are you trying to create?

I'm not too sure. Maybe a commandbutton where when I click it, it'll run that class object? My instructions are to use classes to create that macro only so anything is ok I guess.

[mikerickson]

The result that you are getting can be gotten with the formula =2*SUMIF(Sheet1!A:A, "B")-SUM(Sheet1!A:A)

I don't see any object that could be created or any properties that such an object might have.