avadhutd2
10-06-2009, 02:01 AM
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!
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!