Insert a number by double Clicking

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Insert a number by double Clicking

FAQ

Thread Tools

Display Modes

05-19-2018, 08:35 PM

Logit

Windows 10 Insert a number by double Clicking

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:22 AM.