I replied to your email address just a few minutes ago, and replied here
to the group to inform you of this. It appears as though both my replies
have yet to make it to you as of yet.

As of the forms reference confusion, that original line of code is
actually for MSAccess, I forgot to adjust before sending to you.

When referring to a form control within Excel simply use the form name,
followed by the control name.

UserForm1!ProgressBar.Value = Percent