Hi all,
I need to run a simulation of 5000 iterations. For each iteration, I would expect a msgbox event that requires manual response (click "Yes" or "No" button in the msgbox). I want the msgbox to trigger a VBA code which can automatically assign "Yes" or "No" to the msgbox and close it so as to continue into next iteration. How can I configure excel or VBA to link the VBA code to the msgbox event?
Many thanks.