Visual Basic timeing

[B4L4KS]

hi

is there a way of accessing a sheet but for a certain time, so when i click a button and everything happens and goes onto a sheet for say 5 seconds and then goes off of it

thanks

kristian

 

[Ruddles]

What does clicking the button do and what is the "everything" which is happening?

After it happens, you could wait five seconds and then undo what has happened, if you know at that point exactly what that "everything" is.

Alternatively you could save the sheet before "everything happens", then after it has happened, wait five seconds and reload the sheet from the saved version.

 

[B4L4KS]

hi

when the macro button is clicked it prints off a sheet and then sorts out product orders, then it goes onto a sheet and there i want it to wait open for five seconds before it returns to its original sheet.

order form starts off on and prints off on receipt but doesnt show except for the print icon, and sorts out the products without showing, then moves onto a page to show data, this is where i want it to stay for 5 seconds

thanks

kristian

 

[Ruddles]

Ah sorry, I misunderstood - I thought you were wanting to undo some changes somehow. You just want the macro to pause for a few seconds before continuing.

This will pause for five seconds and then continue:-

application.wait now() + timevalue("00:00:05")

Just insert that at any point in the code where you want it to pause.

If that doesn't display the worksheet when it pauses, you may need to do this:-

with application
  .screenupdating = true
  .wait now() + timevalue("00:00:05")
  .screenupdating = false
end with

 

[B4L4KS]

hi

thank you very much

appreciated greatly

kritian

(F)