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 in? 

 

Thank you guys for helping in advance. 

excel
Formulas and Functions

1 Reply

  • 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