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

[Bobbi]

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]

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 <[email protected]>
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