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

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

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

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

On Mon, 1 May 2006 07:44:02 -0700, Bobbi
wrote:

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