Have a look at using 5 small Spin Buttons from the Forms Toolbar.

Link each button to a cell and click away.


Gord Dibben MS Excel MVP

On 18 May 2007 13:24:59 -0700, Lilguycast wrote:

Well, the thing is that I am getting my information from paper copies.
And all i enter onto the spreadsheet is the total amount of 1-5
ratings for each topic from all of the attendees. Instead of counting
each individual persons response, and then putting it in, i want to be
able to just click on the cell that represents a specific rating, and
it automatically add one value each time i click it. Does that make
sense?