Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to allow the user to double click a cell and have a "X" appear
and to double click again and have the "X" go away. The folowing code does this for column B however I need to do this for columns C and H and not have any requirement that data be in any of the other cells. I appreciate any help on this. Thanks, Robert Private Sub Worksheet_BeforeDoubleClick( _ ByVal Target As Excel.Range, Cancel As Boolean) With Target If Not Intersect(.Cells, Range("B1:B" & Range("A" & _ Rows.Count).End(xlUp).Row)) Is Nothing Then .Value = IIf(.Value = "", "X", "") Cancel = True End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
When double clicking on link in cell it doesn't go the cell. | Excel Discussion (Misc queries) | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |