Mouse click automatically enters character into cell.
How about a double-click??
Put this in worksheet code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Font.Name = "Wingdings 2"
Target.Value = Chr(80)
End Sub
--
Gary''s Student - gsnu200730
"Jeffrey M. Coffin" wrote:
How can I set up a cell to respond to a mouse click by entering a check mark?
|