So helpful. Short and concise to the point. Just 1 observation, @1:46, if we want the progress bar to disappear after 100% completion, just change False to True in the last line before End Sub.
Hello PK, I am looking to do something like this with no loops. My macro has multiple steps just moving/copying/deleting stuff from the workbook. I am new on VBA and having a hard time showing something that can tell people the macros are working. I tried to follow the tutorials for no loops, but I guess its too advanced for me. Any suggestions will be great!
Hello PK sir, Another wonderful tweak to create progress bar using just labels. Wonderful idea. However, one better alternative of VBA.DoEvents could be form.Repaint method to update progress as DoEvents gives user ability to mess up with excel while code is still running!
When the percents are running through: If show the 1% I want see in another label or textbox or like that a text and I want use another comannd button that i can stop or running faster or running back how can I do this issue?
This is cool but when I tried the loop version with my own code that normally took like 15 seconds to run, it took 30 minutes. Not sure why the progress is slowing it down so much.
PK hi, thanks you so much due to share us this video. Great job. I think so, actully you are excel dashboard master. I’m following very closely your dashboard. Could you please upgrade project management dashboard .
Dear sir, your video tutorial is very important for Excel learner, so a request to you, my application, Need multiple files name show when data consolidated in progress bar or status bar , could you please help me, it's very important to me, may you help me , thank you,
As i am new to the coding world i am facing some difficulties to place a progressbar while macro runs ( progressbar for add, delete, update and search from userform to sheet). could you please help me with that if i send you my file?
Hi, How how to add file name display in progress bar when multiple data consolidated, How can I set the Consolidate Multiple Opening File name in the progress Bar display . Could you please help me to deliver A Tutorial ? Please Make a tutorial to get Display Opening Multiple the file name in progress Bar . Thanks mostain Billah
You can use our utility Tool to consolidate the data. I will show the source file also. Please watch below video ua-cam.com/video/1NQj17-3u10/v-deo.html
Please download the practice file and see the code. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
Sir, Thanks for see my comments and revert with your valuable time. Ek request hai apse file ka naam nahi capture ho raha hai. Kripya karke column A me file name capture ka code bhi mentioned kar the
Dim sht As Worksheet Dim LastRow As Long Set sht = ThisWorkbook.Sheets("ITEMS") Dim rng As Range Set rng = sht.Range("ITEM_LIST").CurrentRegion
LastRow = rng.End(xlDown).Row + 1
With sht .Cells(LastRow, 3) = lblItemId .Cells(LastRow, 4) = txtItemname .Cells(LastRow, 5) = lblDate .Cells(LastRow, 6) = txtItemDes .Range("ITEM_LIST").Rows(rng.Rows.Count).Font.Name = "Franklin Gothic Book" .Range("ITEM_LIST").Rows(rng.Rows.Count).HorizontalAlignment = xlCenter End With how could i place your progress bar in this coding..? please help me
So helpful. Short and concise to the point.
Just 1 observation, @1:46, if we want the progress bar to disappear after 100% completion, just change False to True in the last line before End Sub.
Exploring Vba with you is new opportunity.
Thanks for your valuable feedback
Ty.
European ft
Nice solution
I was having problems with the label1 (the bar wasn't upadting)
So I fixed the Me.Label1.Width = Current_W
and it works fine
thanks
Great work bro, its working perfectly.
Thank you so much 😀
Thank you! Very nice, simple and very useful.
Most welcome🙏
Thank u sir I'm searching this from long time 😌
Welcome
that was very helpful for me - tanks a lot.
Most welcome🙏
Thanks for sharing your knowledge .. ☺️
very useful file vba I do like it. PK thank you for sharing it.
Thanks for your valuable feedback
Very nice information Sir
Thanks for your valuable feedback
Thank you so match, Sir.
Welcome
Amazing
Thanks
Thanks, very useful
Thanks for your valuable feedback
مرسی
this is a start but in a real use it will only slow 10 times the execution of whatever needs to be done.
THANK YOU. IT IS VERY INTERESTING. CAN I APPLY IT TO ACCESS DATABASE TO IMPORT EXCEL FILES ? IF SO HOW CAN I DO IT? THANKS
is this a macros specific or for any macro running at the present..??
Hello PK, I am looking to do something like this with no loops. My macro has multiple steps just moving/copying/deleting stuff from the workbook. I am new on VBA and having a hard time showing something that can tell people the macros are working. I tried to follow the tutorials for no loops, but I guess its too advanced for me. Any suggestions will be great!
Hello PK sir,
Another wonderful tweak to create progress bar using just labels. Wonderful idea.
However, one better alternative of VBA.DoEvents could be form.Repaint method to update progress as DoEvents gives user ability to mess up with excel while code is still running!
@@mark99k Okay, good to know that you tested it.
Have you created general ledger in VBA or any video.
When the percents are running through: If show the 1% I want see in another label or textbox or like that a text and I want use another comannd button that i can stop or running faster or running back how can I do this issue?
This is cool but when I tried the loop version with my own code that normally took like 15 seconds to run, it took 30 minutes. Not sure why the progress is slowing it down so much.
PK hi, thanks you so much due to share us this video. Great job. I think so, actully you are excel dashboard master. I’m following very closely your dashboard. Could you please upgrade project management dashboard .
Thank you so much PK Sir for such usefull tutorial, but here you declare Total width as Variant not A single please check
Dear sir, your video tutorial is very important for Excel learner, so a request to you, my application, Need multiple files name show when data consolidated in progress bar or status bar , could you please help me, it's very important to me, may you help me , thank you,
Hi PK, very helpful yaar...btw, can you also show the completion bar?
Thanks
👏👏👏👏
Thanks
As i am new to the coding world i am facing some difficulties to place a progressbar while macro runs ( progressbar for add, delete, update and search from userform to sheet). could you please help me with that if i send you my file?
A error massage, Can not show non-model form when Model form is displayed.
how to move progress bar where i want to stay in a screen?
Hi,
How how to add file name display in progress bar when multiple data consolidated,
How can I set the Consolidate Multiple Opening File name in the progress Bar display . Could you please help me to deliver A Tutorial ?
Please Make a tutorial to get Display Opening Multiple the file name in progress Bar .
Thanks
mostain Billah
hi sir please make video for vehicle maintenance log book
Sir, please create some dashboard for purchase, Procurement
Sir, please provide the code to get the file name from data consolidated in column "A"
Dear Sir. Please help us to get file name also in data consolidatefvsheet
Sir, ek code edit karo ki consoludate data me file name show ho jaye.
Sir, file name is not showing, from which excel file data consolidated.
You can use our utility Tool to consolidate the data. I will show the source file also. Please watch below video
ua-cam.com/video/1NQj17-3u10/v-deo.html
@@PKAnExcelExpert Sir, request you to please apply the code for file name in data consolidated sheet. In beginning or last.
Dear PK,
Please mention the code for consolidated file name in column A
Please provide tha file name also in column A
Dear, i want to file name in each raws.
Please provide the code in consolidated data.
Sir unable to apply progress bar in my data merger sheet
Please download the practice file and see the code.
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
Sir, Thanks for see my comments and revert with your valuable time.
Ek request hai apse file ka naam nahi capture ho raha hai.
Kripya karke column A me file name capture ka code bhi mentioned kar the
Please revert
Dim sht As Worksheet
Dim LastRow As Long
Set sht = ThisWorkbook.Sheets("ITEMS")
Dim rng As Range
Set rng = sht.Range("ITEM_LIST").CurrentRegion
LastRow = rng.End(xlDown).Row + 1
With sht
.Cells(LastRow, 3) = lblItemId
.Cells(LastRow, 4) = txtItemname
.Cells(LastRow, 5) = lblDate
.Cells(LastRow, 6) = txtItemDes
.Range("ITEM_LIST").Rows(rng.Rows.Count).Font.Name = "Franklin Gothic Book"
.Range("ITEM_LIST").Rows(rng.Rows.Count).HorizontalAlignment = xlCenter
End With
how could i place your progress bar in this coding..? please help me