[Solved] Counting the user INPUTS?

[keenkeem]

is there a way to count the number of times a user filled-up a certain cell???

[Villeroy]

Right-click sheet, Sheet Events, Content changed...
Insert blank sheet behind the current one where all changes of all cells are counted in the corresponding cell.

Code: Select all

Sub Sheet1_Changed(e)
'globalscope.basiclibraries.loadlibrary("MRILib")
'MRI e
a = e.getCellAddress()
REM write to next sheet
c = ThisComponent.Sheets(a.Sheet +1).getCellByPosition(a.Column, a.Row) 
c.setValue(c.getValue()+1)
End Sub

[keenkeem]

Sir thanks for your reply. I appreciate it. Last one question, what if you want to count only the number of times a user INPUTS a certain value. like number of times a user inputs yes in a "yes or no" question? (the user inputs X number of Yes out of 10 question something like that, kobe bryants shots 5 out of 10 shots...)

[arrowman]

Right-click sheet, Sheet Events, Content changed...
(...)

Is this possible to define this event in Basic Macro?

[Lupp]

Is this possible to define this event in Basic Macro?

What use? The assignment of a Sub to a sheet event is saved with the document. Once done the setting will persist. No need for a second "macro".

(See also: https://ask.libreoffice.org/en/question ... y-a-macro/.)