User Profile

Collapse

Profile Sidebar

Collapse
ms9
ms9
Last Activity: Nov 19 '07, 07:06 PM
Joined: Nov 19 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ms9
    replied to VBA pausing by tenths of seconds (or milliseconds)
    in Visual Basic
    Trust you but why :
    -the only digit working is 1 ?
    -The routine is used to make a shape moving in excel whith a pause, 1 sec is working (the shape does move) and 1/10sec have no action at all on the shape ?
    Regards...
    See more | Go to post

      Leave a comment:

    • ms9
      replied to VBA pausing by tenths of seconds (or milliseconds)
      in Visual Basic
      Back to the 1/10e sec issue, I did replace the line

      Application.Wai t (Now + ("00:00:01") ) - works fine for 1sec
      by
      Application.Wai t (Now + 0.00001) - works fine for 1sec

      then I tried
      Application.Wai t (Now + 0.000001) - 1/10sec the macro does execute (no bugs) but no action at all 1/10sec perhaps to fast

      then I tried any other digits eg.
      Application.Wai t (Now...
      See more | Go to post

        Leave a comment:

      • ms9
        started a topic VBA pausing by tenths of seconds (or milliseconds)
        in Visual Basic

        VBA pausing by tenths of seconds (or milliseconds)

        I want to pause for a value < of 1 sec

        this is my routine for 1 sec
        Sub Macro1()
        Range("C15").Se lect
        ActiveCell.Form ulaR1C1 = "12"
        Range("E26").Se lect
        Application.Wai t (Now + TimeValue("0:00 :01"))
        End Sub


        I tried with "0:00:00:10 " arguments (to set the pause to 1/10 seconds)
        Application.Wai t (Now...
        See more | Go to post
        No activity results to display
        Show More
        Working...