Results 1 to 6 of 6

Adding a delay

Threaded View

superboy Adding a delay 10-04-2013, 02:09 AM
kvsrinivasamurthy Re: Adding a delay 10-04-2013, 03:35 AM
superboy Re: Adding a delay 10-04-2013, 03:53 AM
djdjdj Re: Adding a delay 10-04-2013, 03:56 AM
superboy Re: Adding a delay 10-04-2013, 04:06 AM
Fotis1991 Re: Adding a delay 10-04-2013, 04:17 AM
  1. #1
    Registered User
    Join Date
    09-25-2013
    Location
    myob,ok
    MS-Off Ver
    Excel 2007
    Posts
    63

    Adding a delay

    I have a macro that open links in column F and Column G, I will like it to open link F and wait 5 seconds before opening Column G. I've manages to make it wait 15 seconds after opening both column F and G but I can't seem to make it wait 5 seconds in between the links in Column F and Column G. Please help me

    Sub OpenLinks()
    Dim r As Range
    With Sheets("Inventory")
        For Each r In .Range("C2:C" & .Range("C" & .Rows.Count).End(xlUp).Row)
            If r.Value < 0 Then
                r.Offset(, 3).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
                r.Offset(, 4).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
                Application.Wait (Now + TimeValue("0:00:15"))
             End If
        Next r
    End With
    End Sub
    Moderator Note:

    Pls use code tags around your code next time as per forum rules.
    Last edited by Fotis1991; 10-04-2013 at 02:16 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro delay
    By jackandjill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2010, 09:41 PM
  2. Delay
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2008, 08:41 PM
  3. delay msgbox?
    By David in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 06:06 PM
  4. Print Delay
    By spartanmba in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 04:06 PM
  5. 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