Forum Discussion

HannahGS1992's avatar
HannahGS1992
Copper Contributor
May 03, 2019

Number

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...
excel
Formulas and Functions
Wyn Hopkins's avatar
Wyn Hopkins
MVP
May 03, 2019

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

 

 

Resources