Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic suddenly stopped working
I have this visual basic code in my spreadsheet.
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address = "$G$10" Then _ Target.Offset(, 2) = Target.Offset(, -2) * Target * (-1) If Target.Address = "$I$2" Then _ Target.Offset(, -2) = Target / Target.Offset(, -4) * (-1) Application.EnableEvents = True If Target.Row < 2 Then Exit Sub Application.EnableEvents = False If Target.Column = 7 Then _ Target.Offset(, 2) = Target.Offset(, -2) * Target * (-1) If Target.Column = 9 Then _ Target.Offset(, -2) = Target / Target.Offset(, -4) * (-1) Application.EnableEvents = True End Sub It worked fine, but suddenly it stopped. How can I make it work again? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic suddenly stopped working
assuming the code was working fine before, I would guess your code stopped
half through and left .EnableEvents=False. In the immediate window run Application.EnableEvents = True and see if the event fires. NickHK "amirstal" wrote in message oups.com... I have this visual basic code in my spreadsheet. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address = "$G$10" Then _ Target.Offset(, 2) = Target.Offset(, -2) * Target * (-1) If Target.Address = "$I$2" Then _ Target.Offset(, -2) = Target / Target.Offset(, -4) * (-1) Application.EnableEvents = True If Target.Row < 2 Then Exit Sub Application.EnableEvents = False If Target.Column = 7 Then _ Target.Offset(, 2) = Target.Offset(, -2) * Target * (-1) If Target.Column = 9 Then _ Target.Offset(, -2) = Target / Target.Offset(, -4) * (-1) Application.EnableEvents = True End Sub It worked fine, but suddenly it stopped. How can I make it work again? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Histogram function suddenly stopped working | Excel Discussion (Misc queries) | |||
Visual Basic code not working when sheet is saved | Excel Discussion (Misc queries) | |||
Data Validation In-Cell Dropdown has Suddenly Stopped being Displa | Excel Worksheet Functions | |||
Excel 2000 suddenly stopped letting me enter data. Help? | Excel Discussion (Misc queries) | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming |