I am having a problem with marking cells as changed.
Cell:
A B C
1 ABC WE PI
2 XYZ ZQ QE
a. I highlight Cells A1, B1, C1 (starting with A1)
b. Then I type the letter X in A1 & tab out.
RESULT:
A1, B1, C1 are bolded & red (all 3 cells fell into the Worksheet_Change event), not just A1.
How can I force it to only look at the cell that changed?
BACKGROUND NOTES:
1. I have the (Tools>Options>Edit Tab) "Edit directly in cell" checked off
2. I am using this code in the "Changed" event of the worksheet.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.Font.ColorIndex = 3
Target.Font.Bold = True
End Sub
Any help is appreciated!
Thanks,
Turbotoan
Cell:
A B C
1 ABC WE PI
2 XYZ ZQ QE
a. I highlight Cells A1, B1, C1 (starting with A1)
b. Then I type the letter X in A1 & tab out.
RESULT:
A1, B1, C1 are bolded & red (all 3 cells fell into the Worksheet_Change event), not just A1.
How can I force it to only look at the cell that changed?
BACKGROUND NOTES:
1. I have the (Tools>Options>Edit Tab) "Edit directly in cell" checked off
2. I am using this code in the "Changed" event of the worksheet.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.Font.ColorIndex = 3
Target.Font.Bold = True
End Sub
Any help is appreciated!
Thanks,
Turbotoan