progressbar in VBA

[mien]

hi...can someone help me how to create progressbar in VBA..thanks..

[ChrisMounts]

First add the "Microsoft ProgressBar Control". To do this go to Tools > Additional Controls. Once you have the control added simply place it on your form.

 

To use it initialize it by setting a max value. This should be the total length of a For / Next loop or something similar. So if I was going to preform some operation on 20 objects I would set it up like this;

frmMain.ProgressBar1.Max = 20

 

Inside your loop you simply set the Progress Bars Value property each time you loop though.

frmMain.ProgressBar1.Value = x

 

Hope this helps.

[mien]

thanks ChrisMounts....problem solved..