1

I want to run the userform with simultaneously running other function so that i dont have to wait more.


UserForm1.Show

'Dim remainder As Long
'Dim i As Long, j As Long
'remainder = 0
'For i = 1 To 200
'UserForm1.Label4.Width = UserForm1.Label4.Width + 1
'''If i Mod 2 = 0 Then
'''remainder = remainder + 1
'''End If
'For j = 1 To 600
'DoEvents
'Next j
'Next i
'Unload UserForm1
'
'MsgBox "Loading is Complete"




'MsgBox "Please Wait ! File are Being Loaded"

Instancecode = GetInstanceCode(Market_Name)
        ' To copy Distributor data file
            Distributor_data_filepath = GetDistributorData_Filepath(Instancecode)
            Distributor_data_FileName = GetDistributorData_Filename(Instancecode)
            Workbooks.Open Filename:=Distributor_data_filepath
            ActiveWorkbook.Sheets(1).Copy After:=Workbooks("FORM_V79_17082020").Sheets(Workbooks("FORM_V79_17082020").Worksheets.count)
        
            
            Workbooks(Distributor_data_FileName).Close
            
          ActiveSheet.Protect "Password", UserInterfaceOnly:=True
          ActiveSheet.Protect AllowFiltering:=True
        

I want to run the user form along with the next function instance code.

Aman Raj
  • 11
  • 2

0 Answers0