Excel VBA - progress bar while macro running

How to create a unique progress bar with Label?

*Syntax:
1. Change the width of the Label:
UserForm5.Label2.Width = c / 100 * 210

2. Change caption on label using VBA:
UserForm5.Label4.Caption = c & "% completed."

3. Call round down function from worksheet function:
Application.WorksheetFunction.RoundDown
- How to create progress bar using OptionButton at https://youtu.be/eMpDHPV2-0M
- How to create progress bar using TextBox at https://youtu.be/Sq1ys6HDBw8

Видео Excel VBA - progress bar while macro running канала Ah Sing's Maths & Excel sharing studio