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!

Sub Book1()

Dim i, j, k, rowcount As Integer

Dim net As Long

rowcount = 2
net = 0

While Worksheets("Sheet1").Cells(rowcount, 1) <> 0
rowcount = rowcount + 1
Wend

For i = 2 To rowcount

If Worksheets("Sheet1").Cells(i, 1) = "B" Then
    net = net + Worksheets("Sheet1").Cells(i, 2) * Worksheets("Sheet1").Cells(i, 3)
    
    Else
    
    net = net - Worksheets("Sheet1").Cells(i, 2) * Worksheets("Sheet1").Cells(i, 3)
    
End If

Next i

MsgBox (net)






End Sub