Mouse click automatically enters character into cell.
Not getting it to run. Boolean) is on the second line (separate from the
start of the parenthetical expression. Is that intended?
"Gary''s Student" wrote:
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?
|