Error 461

[avadhutd2]

Hi,

I am trying to use the progress bar in my task, where I have to show updates on the UserForm using progress bar till all the rows are processed.

When searched over I got the following link, but I am getting Error 461 (Method or data member not found) for the following line -

UserForm1.lblPercent = Str(percentage) & "%"

Got from - http://digiassn.blogspot.com/2006/03/excel-progress-bar-indicator-with-vba.html (http://digiassn.blogspot.com/2006/03/excel-progress-bar-indicator-with-vba.html)

Also, I observed that after putting "." after UserForm1, I am not getting "lblPercent'. What can be the problem?

What should I do to make this code work?

Thanks in advance!

[Paul_Hossler]

Try something like


UserForm1.lblPercent = Format(percentage, "0.0%")


and see it it works

Paul