multiple user forms

[RAJESH1960]

Hello guys,
I have a code which runs for around more or less 10 minutes to get the result depending on the data. I want to use user form to display a progress bar Extracting.. and show the percentage in the bar as 10, 20, ,30...... With one user form it is not possible I hope. So, is it possible to create multiple user forms and enter user form1.show Do Events, user form2..show Do Events, etc., at different lines in the code and get the display till 100 %. ?

 

[RAJESH1960]

Wow!! Just one minute for 1000 rows. Testing for 9000 rows.... I don't think I will need a progress bar after all.

 

[johnnyL]

Replace just that subroutine

 

[RAJESH1960]

Oops.. I forgot to change the range in the CopyGSTIN code. Changed to 10000. Can you please help me to edit the code by editing the range to unlimited.? That part of the code is a recorded macro.

 

[johnnyL]

I will take a look at it after my sleep.

 

[RAJESH1960]

Add2 Key:=Range( _
        "B2:B10000"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    With ActiveWorkbook.Worksheets("GSTIN_to_Verify").Sort
        .SetRange Range("A1:B10000")

Should I remove the 2 from Add2 to make it work in older versions of excel ??

 

[RAJESH1960]

I will take a look at it after my sleep.

Okies.