update a cell by one, trying to count a survey a quick way

Bobbi · May 1, 2006

I am counting a survey and was wondering if there was a way to update a cell
by putting in some type of function so that I do not have delete and update
number every time.

Thanks

Gord Dibben · May 1, 2006

Bobbi

Maybe draw a spinner button on your worksheet? From the Forms Toolbar.

Other method could be use event code to update the cell upon some action.

See John McGimpsey's accumulator code.

http://www.mcgimpsey.com/excel/accumulator.html

Gord Dibben MS Excel MVP