Dear all,

Can anyone help me urgently ?

I set a table sheet and database sheet

1) Database sheet is talking about

Element 1 column A (key word)
Element 2 column B (number of information)
Element 3 column C, D, E.... (Return information under element A)

2) Table Sheet is set sheet_change VBA

If column B input anything and match Element 1 then
Column D will return the information

3) It is worked after I test the code and saved it. I finished my work on that day through this file.

But when I opened the file on next day,
And input any information on Column B in ""table sheet"
The VBA has not been run automatically.

I have checked on web, someone set Ctrl G and set something but its still not worked.

I have created new file and completed the same code again, but it still not worked on the next day.