May 03 2019 02:09 AM
Hey Guys,
How can I select a cell and just by clicking on it, it will go from 1 > 2 > 3 >4 etc.
I need to fill in some data and want to fasten my proces by cliking instead of filling it all in?
Thank you guys for helping in advance.
May 03 2019 03:39 AM - edited May 03 2019 03:41 AM
Hi, @HannahGS1992
If you know a bit about Macros then you could set the style of the cell you want to trigger the 1+ into as something called "Adder" or similar
Then add this code into the worksheet
Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Style = "Adder" Then Target.Value = Target.Value + 1 End If End Sub