Is it possible to have a cell setup to increase the value of the cell by 1
everytime it is clicked? Thanks.

Why not use a spinner button or a scrollbar either from the forms toolbar or
the control toolbox



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"jkbrown" wrote in message
...
Is it possible to have a cell setup to increase the value of the cell by 1
everytime it is clicked? Thanks.

With double-click, use following sub in Worksheet's code:

'----
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Address = "$A$1" Then
Target.Value = Target.Value + 1
Cancel = True
End If
End Sub
'-----

HTH
--
AP

"jkbrown" a écrit dans le message de
news: ...
Is it possible to have a cell setup to increase the value of the cell by 1
everytime it is clicked? Thanks.

I want to be able to change the value with one touch on the touch screen.
That was my first thought on it as well. Thanks for the input.

"Peo Sjoblom" wrote:

Why not use a spinner button or a scrollbar either from the forms toolbar or
the control toolbox



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"jkbrown" wrote in message
...
Is it possible to have a cell setup to increase the value of the cell by 1
everytime it is clicked? Thanks.