Summing with vba

[kelly mort]

Hello Geniuses,

I have a challenge here and I need some bailout :

I have used this to sum up some data in my worksheet . But now I want to add more than one column.

Me.TextBox1.Value =  _ 
WorksheetFunction.SumIf(Sheet1.Range("B7:B1007"),  _ 
Me.TextBox2.Text, Sheet1.Range("F7:F1007"))

Thanks in advance
Kelly

 

[alansidman]

instead of us guessing what column and what data to summarize, why don't be a little more specific and tell us exactly what you expect to happen. Provide examples so we completely understand.

 

[kelly mort]

I am summing up col F, col H, col J, col L and col N.

And this should happen when I click the Listbox.

Thanks again.
Kelly