Macro work out of sequence
Posted: Sun Sep 10, 2017 7:54 am
I had attach the sample file for parallel data collection "test1" & "test2"(macro was create at excel 2010).
How it work:
1)once user update the data at "test1", the data will store at sheet 1 and "test2" file.
2)"test2" file won't display on screen, the screen just blink and auto close.
Problem now:
1) after "test1" update the data, the data will store at both of the file but the "test2" file can not auto close.
Hope can get consult for all the "GURU" at here.
How it work:
1)once user update the data at "test1", the data will store at sheet 1 and "test2" file.
2)"test2" file won't display on screen, the screen just blink and auto close.
Problem now:
1) after "test1" update the data, the data will store at both of the file but the "test2" file can not auto close.
Hope can get consult for all the "GURU" at here.