I have created the new userform and included the Microsoft progress  bar into
that. But when i execute the user form is waiting until I press close button  of
the progress bar  user form and then its moving on to the next record.

Moreover, I am unable to understand the below mentioned command.

"Forms!frmMain! EmpProgressBar. Value = Percent 'Make sure to use your
form name, and name of control!!"

I have enclosed the excel  file with coding for your easy reference. Could you
please help  me out at the earliest?