I'm trying to combine code that will add/remove a check mark and change the color to yellow when the check mark is added and change it to no fill when removed. I know virtually nothing about VBA code though.
I have this code that adds/removes the checkmark fine:
I have used this subroutine to define an entire worksheet several times.
Private Sub worksheet_beforedoubleclick(ByVal Target As Range, Cancel As Boolean)
But I would like to be more surgical and specify specific cells. I need to detect a double click F2, F4, F6, F8 and F10, each of these...
After doing the following to make cells coloured after double clicking them:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Interior.ColorIndex = xlNone Then
' Then change the background color to red
Target.Interior.ColorIndex = 8...
Bacically i want to write a Macro that will select each cell one at a time and double click it!!
I think it's supposed to look similar to this:
Dim TheCell As Range
For Each TheCell In ActiveSheet.UsedRange
ActiveCell.FormulaR1C1 = ""
Working in Excel 2007. Switched from XP to Vista (not sure if that matters). For some reason, I can no longer edit the contents of a cell by double-clicking. I have to edit in the toolbar. Is there a way to enable/disable the double-click editing function?