Excel 2007

I would like to add a counter to a spreadsheet (actually several counters)

I would prefer NOT to use a macro

I would prefer to use an object or a clip art of something so that when I
click it, it adds +1 to a specified cell.

I read a previous post on formating a spinner shape. No idea what that is.

Anyone know the steps to do this?

Many thanks!!!!

If you use a spinner control from the Forms toolbar, and link this to a cell
(right-click the control, select Control, and put a cell reference in cell
link), and this will increment on click.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"23Hitamn" wrote in message
...
Excel 2007

I would like to add a counter to a spreadsheet (actually several counters)

I would prefer NOT to use a macro

I would prefer to use an object or a clip art of something so that when I
click it, it adds +1 to a specified cell.

I read a previous post on formating a spinner shape. No idea what that is.

Anyone know the steps to do this?

Many thanks!!!!

Excel 2007................cant find Forms much less a toolbar anymore :)
Tab? Ribbon?

Thank you



"Bob Phillips" wrote:

If you use a spinner control from the Forms toolbar, and link this to a cell
(right-click the control, select Control, and put a cell reference in cell
link), and this will increment on click.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"23Hitamn" wrote in message
...
Excel 2007

I would like to add a counter to a spreadsheet (actually several counters)

I would prefer NOT to use a macro

I would prefer to use an object or a clip art of something so that when I
click it, it adds +1 to a specified cell.

I read a previous post on formating a spinner shape. No idea what that is.

Anyone know the steps to do this?

Many thanks!!!!

The forms toolbar has been replaced in 2007 with a button in the Controls
Group of the Developer tab.

The Insert button gives you access to the Forms controls and the ActiveX
controls.

The developer tab is not visible by default, so you have to make it so. This
is done by clicking the Office button, then click Excel options, and in the
Popular pane, check the Developer tab in the Ribbon.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"23Hitamn" wrote in message
...
Excel 2007................cant find Forms much less a toolbar anymore :)
Tab? Ribbon?

Thank you



"Bob Phillips" wrote:

If you use a spinner control from the Forms toolbar, and link this to a
cell
(right-click the control, select Control, and put a cell reference in
cell
link), and this will increment on click.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"23Hitamn" wrote in message
...
Excel 2007

I would like to add a counter to a spreadsheet (actually several
counters)

I would prefer NOT to use a macro

I would prefer to use an object or a clip art of something so that when
I
click it, it adds +1 to a specified cell.

I read a previous post on formating a spinner shape. No idea what that
is.

Anyone know the steps to do this?

Many thanks!!!!