change value with single click, increasing by 1 every time?
 

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

change value with single click, increasing by 1 every time?
 

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.

change value with single click, increasing by 1 every time?
 

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.

change value with single click, increasing by 1 every time?
 

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.