title: Excel Macro VBA: How to allow ONLY double click as input on a specific column?
body: <p>How can I make column 6 (F) and 13 (M) to accept inputs only when I double click, which means it should not accept any numbers, letters or symbols and even the "delete" button but double click?</p>
  
  <p>The following is the code I have worked out:</p>
  
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
  
  Checking whether target cell is in third column
  Select Case Target.Column
  Case 6, 13
  
  If Not Intersect(Target, Range("F2:F13, M2:M13")) Is Nothing Then Cancel = True
  
  'Prevent cell going into Edit Mode
  Cancel = True
  
  'Changing font type of the cell
  Target.Font.Name = "Marlett"
  
  'Checking if target cell value is blank then inserting tick
  If Target = "" Then
      Target = "a"
  Else
      MsgBox "You cannot modify the cell."
  End If
  End Select
  
  End Sub
  </code></pre>