Insert a number by double Clicking

byrner · #1 05-19-2018, 04:01 AM

Hi to All
Just stuck with excel and hoping someone can help?
The code below allows me to insert (0) between columns G and I just by left double clicking,
But i need to extend this to columns V . So it works from columns G to V.

I got this formula from another site but don't really understand it but it works
Thanks again to all

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("G:I")) Is Nothing Then Exit Sub
Cancel = True
Target.Value = IIf(Target.Value = "", 0, "")
End Sub

Logit · #2 05-19-2018, 08:35 PM

Code:

Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range("G:V")) Is Nothing Then Exit Sub
Cancel = True
Target.Value = IIf(Target.Value = "", 0, "")
End Sub

Pecoflyer · #3 05-20-2018, 12:10 AM

@byrner
Hi and welcome to the board.
To make code easier to handle on the forum, it's best to wrap it with code tags ( I did it for you on the first post).
To accomplish this click " go advanced", elect the code and click the #button.
Thanks

byrner · #4 05-20-2018, 02:27 AM

Hi thanks to all , I now have it working Thanks again
Regards

Logit · #5 05-20-2018, 09:07 AM

You are welcome.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I insert pictures directly into picture boxes by clicking the box instead of using INSERT>PIC	Bree	Word	1	06-24-2016 10:32 PM
Formula cells are not highlighted when double clicking result	hockeytown	Excel	2	12-03-2015 09:57 AM
Can't open Word files when double-clicking	JosieNurse	Word	9	04-21-2015 11:31 AM
Problem with page and chapter number appearing when clicking in the scroll bar	Tango Mike	Word	0	05-05-2014 07:12 AM
Insert the Hyperlink and hide all sheets except clicking Hyperlink	PRADEEPB270	Excel	1	02-22-2013 09:47 AM