Ultimate Progress Bar Control in VBA Userform

Подписаться 276 тыс.

Просмотров 40 тыс.

50% 1

#ProgressBar #VBAUserForm
Hello Friends,
In this video, you will learn how to develop a Progress Bar in Excel VBA. I have also explained, how can you integrate this Progress Bar with your existing VBA Project. You can use this Progress Bar inside the Loop or without Loop also.
Download the practice files from below given link:
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Time Picker in Excel VBA-
• Time Picker and Date T...
Data Consolidation Macro-
• Data Consolidation and...
• Data Consolidation and...
• Data Consolidation: Al...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@Husky_Passion 3 года назад

this is a start but in a real use it will only slow 10 times the execution of whatever needs to be done.

@mostainbillah 16 дней назад

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

@mostainbillah 17 дней назад

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,

@charlessteve1911 2 года назад

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

@Harshsanjana Год назад

Sir, ek code edit karo ki consoludate data me file name show ho jaye.

@busyshah 3 месяца назад

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.

@aydnb.1406 Год назад

how to move progress bar where i want to stay in a screen?

@kaueadm Год назад

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

@rickylguzman Год назад

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!

@NeangBona 3 года назад

very useful file vba I do like it. PK thank you for sharing it.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@jmathew6988 Год назад

Thank you! Very nice, simple and very useful.

@PKAnExcelExpert Год назад

Most welcome🙏

@jaminee3 2 года назад

A error massage, Can not show non-model form when Model form is displayed.

@CumhurK Год назад

Great work bro, its working perfectly.

@PKAnExcelExpert Год назад

Thank you so much 😀

@jamespyle6398 Год назад

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.

@breakingbad582 3 года назад

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 .

@chaiyya345 3 года назад

Hi PK, very helpful yaar...btw, can you also show the completion bar? Thanks

@charlessteve1911 2 года назад

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?

@ets2atstruckermartin527 Год назад

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?

@MrSilentv 11 месяцев назад

that was very helpful for me - tanks a lot.

@PKAnExcelExpert 11 месяцев назад

Most welcome🙏

@ArmanKhan-iq3ji 3 года назад

Thank u sir I'm searching this from long time 😌

@PKAnExcelExpert 3 года назад

Welcome

@sisoader7391 2 года назад

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

@395mazhar 3 года назад

Sir, please create some dashboard for purchase, Procurement

@vv9730 11 месяцев назад

is this a macros specific or for any macro running at the present..??

@davebalino Год назад

Amazing

@PKAnExcelExpert Год назад

Thanks

@Tamilneasan 3 года назад

hi sir please make video for vehicle maintenance log book

@MohAboAbdo 3 года назад

Thank you so match, Sir.

@PKAnExcelExpert 3 года назад

Welcome

@OyeitsAmitSharma 3 года назад

Thank you so much PK Sir for such usefull tutorial, but here you declare Total width as Variant not A single please check

@abdulsafwan4419 3 года назад

Thanks for sharing your knowledge .. ☺️

@msantosh1220 3 года назад

Exploring Vba with you is new opportunity.

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@kavithagovindu1486 3 года назад

Ty. European ft

@sefaelmas8501 3 года назад

👏👏👏👏

@PKAnExcelExpert 3 года назад

Thanks

@umairtaqi5602 3 года назад

Have you created general ledger in VBA or any video.

@temyraverdana6421 3 года назад

Thanks, very useful

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@prasantha1972 3 года назад

Very nice information Sir

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@nikhilhalari9774 3 года назад

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!

@nikhilhalari9774 3 года назад

@@mark99k Okay, good to know that you tested it.

@Harshsanjana 2 года назад

Sir unable to apply progress bar in my data merger sheet

@PKAnExcelExpert 2 года назад

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

@Harshsanjana 2 года назад

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

@Harshsanjana 2 года назад

Please revert

@Harshsanjana 2 года назад

Sir, please provide the code to get the file name from data consolidated in column "A"

@Harshsanjana 2 года назад

Dear Sir. Please help us to get file name also in data consolidatefvsheet

@alializadeh8195 2 года назад

مرسی

@Harshsanjana 2 года назад

Sir, file name is not showing, from which excel file data consolidated.

@PKAnExcelExpert 2 года назад

You can use our utility Tool to consolidate the data. I will show the source file also. Please watch below video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1NQj17-3u10.html

@Harshsanjana 2 года назад

@@PKAnExcelExpert Sir, request you to please apply the code for file name in data consolidated sheet. In beginning or last.

@Harshsanjana 3 года назад

Dear PK, Please mention the code for consolidated file name in column A

@Harshsanjana 3 года назад

Please provide tha file name also in column A

@Harshsanjana 3 года назад

Dear, i want to file name in each raws. Please provide the code in consolidated data.