Progress Bar

[laxmanann]

Hi all,

Im consolidating datas from muliple excel files to single data base excel file.Am having macro and it is working fine for me.But when am loading data to data base file the excel files are vibrating.To avoid this issue i want to Set the progress bar which should indicate the progress of the data loading.Can any one help me out to set the progress bar.

I have attached my files in the below path.

http://www.excelforum.com/excel-prog...cel-macro.html


Can any one pls take a look and help me in setting the progress bar.


Thanks,
Lakshmanan

[ragulduy]

Hi, have you turned off screenupdating?

i.e.

Please Login or Register  to view this content.

Im guessing that might fix what you refer to as vibrating.

I find the easiest way to display a progress bar is to use the status bar:

Please Login or Register  to view this content.

then to reset it:

Please Login or Register  to view this content.

[laxmanann]

Hi Ragulduy,

Thank you so much for the reply..But i didn't understand your question.And also where i need to Put this code and all.Do i need to Use userform to Show the progress bar Or something else.Please help me to updating this code.And i didnt turned off anything in my code or sheet.I have Just coded to retrive the datas from multiple sheet.Please refer the sheets placed in the below url and Help me to put the code in that sheet.


http://www.excelforum.com/excel-prog...cel-macro.html


Thanks Much,
Lakshmanan

[ragulduy]

Hi, as per the example I gave you, you need to wrap the screenupdating tags around your code. For example, in the link you share, the code:

Please Login or Register  to view this content.

would become:

Please Login or Register  to view this content.

the code:

Please Login or Register  to view this content.

will make the text 50% appear in the excel status bar, you do not need a userform to display it.

[laxmanann]

Hi Ragulduy,


Am trying to put the code in new module..It s not running and i dont know where i can put the code ..Else i need to put the code through userform..Please advice..

Thanks,
Lakshmanan

[ragulduy]

Hi, sorry, I don't think I am able to help further.

[laxmanann]

Hi Hi Ragulduy,

Sorry for the 5th thread reply..I din See your 4th Message.I just hit enter before browser loading..sorry for the inconvinence.Am trying to delete 5th message..But i couldnot...


Thanks

Hi Ragulduy,


Am trying to put the code in new module..It s not running and i dont know where i can put the code ..Else i need to put the code through userform..Please advice..

Thanks,
Lakshmanan

[laxmanann]

Hi Ragulduy,

Im placing My code here..Please and correct if im wrong.

Please Login or Register  to view this content.

[Marc L]

Hi,

just for information, using an UserForm progress bar increases process time as twice and more …

[laxmanann]

Hi Marc L,

Thanks for the information.There is no pbm regarding time constraint and all.Just to show as mush as grt or like presentation of my macro is worthy i guess..Please assist something related to progress bar using userform.Expecting your positive reply Marc L..


Thanks,
Lakshmanan

[laxmanann]

Hi Marc L,

Thanks for the information.There is no pbm regarding time constraint and all.Just to show as mush as grt or like presentation of my macro is worthy i guess..Please assist something related to progress bar using userform.Expecting your positive reply Marc L..


Thanks,
Lakshmanan

[Marc L]

See Progress Meters for example …

[laxmanann]

Hi Marc L,

I have gone through the website which was shared b you..But im nt able to apply that it is in my project in the below link.can you please help me out..

http://www.excelforum.com/excel-prog...cel-macro.html

Thanks in advance,
Lakshmanan