Number

%3CLINGO-SUB%20id%3D%22lingo-sub-524196%22%20slang%3D%22en-US%22%3ENumber%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524196%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Guys%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20select%20a%20cell%20and%20just%20by%20clicking%20on%20it%2C%20it%20will%20go%20from%201%20%26gt%3B%202%20%26gt%3B%203%20%26gt%3B4%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20fill%20in%20some%20data%20and%20want%20to%20fasten%20my%20proces%20by%20cliking%20instead%20of%20filling%20it%20all%20in%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20guys%20for%20helping%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-524196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524404%22%20slang%3D%22en-US%22%3ERe%3A%20Number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524404%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332779%22%20target%3D%22_blank%22%3E%40HannahGS1992%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20know%20a%20bit%20about%20Macros%20then%20you%20could%20set%20the%20style%20of%20the%20cell%20you%20want%20to%20trigger%20the%201%2B%20into%20as%20something%20called%20%22Adder%22%20or%20similar%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20484px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111912iED296E581A0D87B6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20add%20this%20code%20into%20the%20worksheet%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20889px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111913i82F237E9BD6E4D5A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3EOption%20Explicit%0A%0APrivate%20Sub%20Worksheet_SelectionChange(ByVal%20Target%20As%20Range)%0A%0AIf%20Target.Cells.Style%20%3D%20%22Adder%22%20Then%0A%0ATarget.Value%20%3D%20Target.Value%20%2B%201%0A%0AEnd%20If%0A%0A%0AEnd%20Sub%0A%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
HannahGS1992
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

 

image.png

 

 

Then add this code into the worksheet

 

 

 

image.png

 

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