Tricky one.

[rickwardyy]

Ok so I'm a novice at Excel so be easy on me!

So I have a spreadsheet and I need to add an amount up.. It's hard to explain so for example.

I have someone pays me £200, I need a box where I can enter £200 and it'll add up in the box next to it.. When I press enter I need box I typed £200 in clear and then when another client pays £180 I enter £180 in the same box which automatically clears and it adds up in the box next to it so now the amount is £380.

Any help would be much appreciated.

Thanks in advance.

 

[liiamra]

Hi,

The main question is:

Do you want to do this with a form? Or you mean the box is an Excel cell?


Regards//

 

[rickwardyy]

Hi,

The main question is:

Do you want to do this with a form? Or you mean the box is an Excel cell?


Regards//

Sorry I want to do it in a box on excel.

 

[liiamra]

What Box? ActiveControl text box? comboBox?