27 VBA Advanced Progress Bar in Excel

preview_player
Показать описание
27 VBA Advanced

Follow-up of VBA Beyond Basics and VBA for EveryOne Series

Topics in this Video:
Progress Bar like Software Installation
Show Modal

*Post Video:*
Change Progress Bar Color:
BarColor = BarColor + 10000
UserForm1.Bar.BackColor = BarColor

*Code:*

Sub vProgressBar()

UserForm2.Show

For vMyLoop = 1 To 100 Step 10
UserForm2.Label1.Width = vMyLoop
DoEvents
Application.Wait (Now + TimeValue("0:0:01"))
Next vMyLoop

UserForm2.Hide

End Sub
Рекомендации по теме
Комментарии
Автор

I was trying to create a progress bar and watched so many videos on this topic, but failed. Finally got it why my bars were not working. it helped me a lot. jazakallahu khair.

md.ahsanulalamnaiem
Автор

Great sir, what the about the the color changing while progress run? His you did it

redhaakhund
Автор

Salam,
Merci pour la vidéo, c'est magnifiques, ce que je voudrais savoir comment vous faites pour afficher le pourcentage . Vous ne l'avez pas expliquer. Merci beaucoup et bonne réussite.

abdelmoumenamghar