Skip to content

Instantly share code, notes, and snippets.

@danwagnerco

danwagnerco/clear_cell_contents_on_click.vb

Created April 14, 2017 17:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danwagnerco/9f98338bf74ad1eccd88d01cc7d09358 to your computer and use it in GitHub Desktop.
Save danwagnerco/9f98338bf74ad1eccd88d01cc7d09358 to your computer and use it in GitHub Desktop.
Download ZIP
Placed in the Worksheet you'd like this mode to work in, you can clear cell contents by simply clicking the cell, which allows for instant editing
Raw
clear_cell_contents_on_click.vb
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.FormulaR1C1 = ""
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment