View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeffrey M. Coffin Jeffrey M. Coffin is offline
external usenet poster
 
Posts: 3
Default 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?