Input box help

[jamesstorx]

I need help getting an input box to open when the user clicks on a Cell (A3) I then want the number that is entered to be added to E3. everytime the user enters a number I want need it to add to the existing total
(Eg, E3=10 User enters 5, E3 now equals 15.)
The total should just keep growing. The worsheet has approx 900 lines (starts at A3) I am trying to keep running totals.
I am not sure if I need to have hidden sheets to get it to keep adding to the existing totals.


Thanks for your help.

--James

[dominicb]

Good evening jamesstorx

I need help getting an input box to open when the user clicks on a Cell (A3) I then want the number that is entered to be added to E3. everytime the user enters a number I want need it to add to the existing total

Something like this should work OK :

Please Login or Register  to view this content.

HTH

DominicB

[jamesstorx]

This works for the one cell, but I ned to make it work on any cell in that column. I am no sure how to manipulate this to do that.

[royUK]

Try his amendment

Please Login or Register  to view this content.

[jamesstorx]

That worked Great! thanks alot.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save