I'm trying to set a pause in my code so that when someone clicks command button 1 it saves their data into a text file and then brings up a msgbox telling them that the data has been logged. After about 3 secs I need to box to close down automatically and leave the form up to enter more data.
I have tried using 'Next' and counting values up until they reach a set figure but it still does not pause the message box.
Has anyone got any ideas? Many thanks if you do.
Simon
I have tried using 'Next' and counting values up until they reach a set figure but it still does not pause the message box.
Has anyone got any ideas? Many thanks if you do.
Simon