+ Reply to Thread
Results 1 to 4 of 4

10 Second Delay in VBA Printing

  1. #1
    Registered User
    Join Date
    03-16-2020
    Location
    Nairobi, Kenya
    MS-Off Ver
    Office 2016
    Posts
    24

    10 Second Delay in VBA Printing

    Dear Excel Forum,

    I am Working on a small project (Attached)

    in the Names List workbook, when i click print it initiates a print for the receipt workbook.

    I have struggled to add a 10 SECOND delay on the print because on a receipt printer it is printing too quickly

    Requesting assistance to help in adding a VBA code to help in creating a 10 second delay between the printing of each rows.

    I would appreciate
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: 10 Second Delay in VBA Printing

    Try inserting the below:

    Please Login or Register  to view this content.
    Last edited by ORoos; 05-23-2020 at 09:00 AM.

  3. #3
    Registered User
    Join Date
    03-16-2020
    Location
    Nairobi, Kenya
    MS-Off Ver
    Office 2016
    Posts
    24

    Re: 10 Second Delay in VBA Printing

    Thank you.
    i will give it a try and reply back once i have tried

  4. #4
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: 10 Second Delay in VBA Printing

    Hi NirajB,
    You only need to insert the 1 line (in blue) in your code. The 3 other lines are your code towards the end.
    Basically it needs to be inside the loop that prints each row.
    Trust this helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Time Delay
    By iqballud in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2017, 06:06 PM
  2. IF rechecked after delay
    By fredpox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2010, 05:47 PM
  3. Delay during a web query
    By miltuf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2009, 11:34 AM
  4. Delay
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2008, 08:41 PM
  5. refresh from web with delay
    By newdude in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-26-2007, 01:45 AM
  6. Print Delay
    By spartanmba in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 04:06 PM
  7. [SOLVED] delay on copy
    By klyyss in forum Excel General
    Replies: 3
    Last Post: 01-10-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1