Pausing Using VB, version 6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sedge
    New Member
    • Jun 2007
    • 1

    #1

    Pausing Using VB, version 6

    Hi, Im writing a program! from a java timing prog. an excel sheet is spat out, with information to make a graph. what i dont know is how to put a pause between the sheets so u can see the graph. im using VB version 6 and the code looks something like this:
    Sub Macro3()
    '
    ' Macro3 Macro
    ' Macro recorded 7/06/2007 by Sedge
    '
    ' Keyboard Shortcut: Ctrl+q
    Sheets("Sheet2" ).Select
    End Sub

    i dont know where or how to add a pause of 10 to 20 second!!
    Can somebody Please help me!!!

    Thanks Sedge
Working...