Excel VBA - progress bar while macro running

How to create a unique progress bar with OptionButton?

*Syntax:
1. Use option button with variable:
UserForm5.Controls("OptionButton" & k).Value = True

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

3. Call round down function from worksheet function:
Application.WorksheetFunction.RoundDown