I want to double click a box and have an X inserted there?

[Guest]

I am setting up a cover sheet 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?

 

[Gord Dibben]

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

 

[Guest]

You are correct, I am using a cell with a border and I wish it to be filled
in when double clicking on the cell kind of like in word. I am using this
to create a pricing system and linking this to numerical data.

 

[Gord Dibben]

Then either of the methods I gave will enter a checkmark in the cell.

How you would link these to numeric data is another problem which I hope you
have solved.


Gord