justuptou
01-30-2018, 05:55 AM
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.
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.