Link to home
Start Free TrialLog in
Avatar of J G
J G

asked on

can't find event handler in excel

I have a spreadsheet when you type a value in column a, a corresponding calculated field gets triggered in column b.

so... I type 5 in field a2 and 6 (=a2+1)appears in column b2.   The problem is that this spreadsheet was created 7 years ago, and I cant find or remember where the event handler code lives.  When I look in macros/vba no modules exist.  when I copy and paste both columns into a new worksheet/workbook the calculated field still works.  

If I click into fields a3 or b3 no data exists.  If I type a value in a3 and hit enter, the calculated field in b3 appears.  Can someone help me find the code or where the event trigger exists?
Avatar of FarWest
FarWest

is it possible to give a sample that contains the case?
of course I assume that it is not a formula with auto calculation enabled :)
Avatar of Martin Liss
Is there a formula in B2? Is the code in the sheet's Worksheet_Change event or any other worksheet event?
Have you looked in the ThisWorkbook module?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Is it possible that the worksheet is protected, with formula's hidden? Otherwise, to go directly to the worksheets code module which will contain the appropriate handler, right-click the worksheets tab and select "View Code".