Re: I want to double click a box and have an X inserted there?
- From: Gord Dibben <gorddibbATshawDOTca>
- Date: Tue, 09 Oct 2007 13:46:00 -0700
What is a "box"? A cell?
You would need event code to achieve the double-click in a cell.
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
Target.Value = "a"
Target.Font.Name = "Marlett"
Cancel = True
End Sub
Might be easier to format the cell to Marlett font and just type an "a" to
return a checkmark and dispense with the double-clicking.
Gord Dibben MS Excel MVP
On Tue, 9 Oct 2007 12:49:02 -0700, JLM <JLM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am setting up a cover *** that I want to have the user double click a box
and have an X inserted in the box or a check. How do I complete this task?
.
- Prev by Date: Re: How do I create a list in excel 2007?
- Next by Date: Re: Macro REQ: Automatically copy a template *** and rename
- Previous by thread: Re: How do I create a list in excel 2007?
- Next by thread: Re: I want to double click a box and have an X inserted there?
- Index(es):
