Clicking in a Cell

**vidya.ml** · 03-03-2011, 08:17 PM

Hi,

I'm facing this problem since two days. Like we have Application.DoubleClick to double click on ActiveCell, is there a way to perform a single click on the cell?

I want this to do because i have checkboxes embedded in each cell in excel sheet and want to check or uncheck them based certain condition.

I tried to use checkbox control methods, but not successful as the checkbox is not getting identified.

Please let me know if anyone has come across this kind of issue and what you did to overcome it.

Thanks,
Vidya

**jwright650** · 03-03-2011, 08:32 PM

checkboxes return a true or false

Attach a dummy workbook where you need checkboxes, might could get it going for you...if not too difficult

**MarvinP** · 03-03-2011, 08:55 PM

Hi Vidya and welcome to the forum.

I've found check boxes are way too much overhead for what you get. Find the attached where a double click anywhere in column A will add an X or remove the X in any row.

See the code behind Sheet1 to see what is happening and use it for your own workbooks.
The code looks like:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column <> 1 Then GoTo Ender
    If Target.Row = 1 Then GoTo Ender
    If Target = "x" Then
            Target = ""
    GoTo Ender
    End If
    If Target = "" Then
            Target = "x"
    End If
Ender:
    Cancel = True
End Sub

You can then check for an x in the cell instead of dealing with checkboxes.