Occasional Visitor

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. 

1 Reply

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



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies