How to sum in excel?

[cbouvry]

I've made a button in excel and i want to add a macro to it. The purpose is to add "1" to the content of cell"J8". So each time i press the button, J8 should become 1 bigger. (example: J8 was "54", after pressing the button it should be "55")
Could someone help me?
thx!!

 

[xlbo]

what is this for ??

 

[cbouvry]

It's for a poll i'm making. Each question has mumltiple answers. I would make a button for each answer. Only clicking the button would would adjust the number of responses of that answer. but i have no idea what vb script i have to put.

 

[xlbo]

Have you used VBA before? (not being funny - just trying to establish level of knowledge)

 

[cbouvry]

yes, but long ago. the solution might be very simple, but i can't repeal it.

 

[xlbo]

the code you require is:

Range("J8").value = Range("J8").value + 1

You should be able to find out how to create a module and add a sub routine / macro into it from the help files...

 

[cbouvry]

thx!

 

[4808]

Hi

I'm try to get excel to add some numbers as i enter them in each row continuosly. every time i enter numbers in a row it adds them automatically.

can anyone help?

thanks
alph

 

[SkipVought]

4808,

Please post your question in a new thread.

Skip,
[sub]
[red]Be Advised![/red] A man's home is his castle...
in a Manor of speaking. [/sub]

 

[4808]

I'm sorry don't know what happened there.