Cummulative Summing in Cell

[Makpo]

Hi,

I need to create a vba or a macro that adds numbers from a userform to the number already existing in a particular cell without encoutering circular reference. Any help?

 

[Makpo]

I rephrase, counting consecutive values from a userform into a cell that already had a number, without deleting the number in that cell. Rather the new number from the userform adds to the old one;

C1 has 10
we add 4 to C1 and it results in 14. Please help!

 

[Smitty]

Welcome to the Board!

How's this:

Range("C10").Value = Range("C10").Value + Me.TextBox1.Value

HTH,

 

[Scott Huish]

Assuming you have an OK button:

Private Sub CommandButton1_Click()
With Sheets(1).Range("C1")
    .Value = .Value + Val(TextBox1)
End With
End Sub

 

[Makpo]

Wow Guys!

Thanks I actually left my computer and went to out of the house. Yeah! I didn't realize how fast people respond. I just got back. Thanks once again. Next time, I'll stay close to the computer after a post.

 

[Smitty]

Wow Guys!

Thanks I actually left my computer and went to out of the house. Yeah! I didn't realize how fast people respond. I just got back. Thanks once again. Next time, I'll stay close to the computer after a post.

Don't feel bad, I'll often start to answer a post only to walk away and come back and find that the question's already been answered. You've got to stay on your toes with this bunch.