Excel to automatically add to one cell

[posfog]

Hi All,
I just wondered if someone could advise on how the follow.

I need to be able off the back of a macro for one cell to keep a count of every time a button is pressed.

I google sheets i know this is possible with the following function as show below, but wondered if the same could be done in excel?

function b4plus() {
ss=SpreadsheetApp.getActiveSpreadsheet()
s=ss.getActiveSheet()
var currVal=s.getRange("B9").getValue()
var plusVal= currVal +1
s.getRange("B9") .setValue(plusVal)
}

Kind Regards

 

[Michael M]

Use this and simply assign it to your button

Sub MM1()
Sheet1.[B9] = Sheet1.[B9].Value + 1
End Sub

 

[posfog]

Thanks for that

Am i correct in thinking if i wanted it to remove (minus 1) i do the following?

Sub MM1()
Sheet1.[B9] = Sheet1.[B9].Value - 1
End Sub

 

[Michael M]

yep...easiest way, give it a try and see what happens !!!

 

[posfog]

Many Thanks Michael M

yep...easiest way, give it a try and see what happens !!!