Status Update Box

  • My macro involves iterating thru' a loop close to 500 times, and each iteration involves some movement back and forth between Sheet1 and Sheet2. Thus I have set 'Application.ScreenUpdating = False' just before the start of the iteration to prevent screen flicker and hopefully to speed up the iteration process.


    However, altho' the screen thus appears 'frozen' during the iterative process, I would like a real-time 'status update' box to appear at the start of the iteration; something like: 'Currently Running Iteration 24 of 500', where '24' is the current value of the loop counter within the macro code; next loop increments this to '25', etc.


    If anyone has done something similar, pls advise with code. Thanks in advance

  • Re: Status Update Box


    Code
    for i=1 to 500
        application.statusbar="Currently running iteration " & i & " of 500"
       ' other code here
    next
    application.statusbar=false

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!