Change Event Example
Home > IT Answers > Development > Change Event Example
MAPALMERMA
5 pts.
0
Q:
Change Event Example
Visual Basic 6
I copied the Change Event Example from Help:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.ColorIndex = 5
End Sub
into a module, but when I change the worksheet, it doesn't run. Do I have to enable it in some way?

Thanks in advance,
Mike
ASKED: Jul 22 2009  9:15 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29845 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I think you need to put that code in the private module of the worksheet, not in a separate module.
Also, excel will probably disable macros as a security measure, so you have to make sure they are enabled.
Last Answered: Jul 22 2009  9:49 PM GMT by Carlosdl   29845 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0