gimli
05-03-2010, 06:25 AM
Hey all,
Curious how this statement will work. F13 calls sub test1 and the next line test 2. Will both the subs be called or will it stop at test1? Seems like it only runs test 1. Im guessing I should change the code and put test 1 and test 2 under F13.
Thanks much
private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Exits
Application.EnableEvents = False
Select Case Target.Address
Case "$F$13"
Call test1
Case "$F$8", "$F$9", "$F$13", "$E$13"
Call test 2
Case "$F$12"
Call test3
End Select
Exits:
Application.EnableEvents = True
End Sub
Curious how this statement will work. F13 calls sub test1 and the next line test 2. Will both the subs be called or will it stop at test1? Seems like it only runs test 1. Im guessing I should change the code and put test 1 and test 2 under F13.
Thanks much
private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Exits
Application.EnableEvents = False
Select Case Target.Address
Case "$F$13"
Call test1
Case "$F$8", "$F$9", "$F$13", "$E$13"
Call test 2
Case "$F$12"
Call test3
End Select
Exits:
Application.EnableEvents = True
End Sub