Results 1 to 10 of 10

Thread: Excel VBA Delete after timer

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,959
    In the attached are your 2 sheets.
    Go to the Cache sheet where you'll find a button. Click it once and data will be copied from the Hotel Booking sheet. Wait 10 seconds and that data should be deleted.
    Next click the same button, but 3 times at intervals of about 3 seconds. I've added a line to increment the values of the range on the Hotel Booking sheet so that the ranges are identifiable on the Cache sheet. You should see the copied ranges appearing, then 10 seconds after each range was pasted, disappearing, in the order they were pasted.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •