Countdown timer with HP bar on UserForm

Create countdown timer with HP bar in Excel by using UserForm. Change caption and font color of command button automatically. Add numbers to combo box by using for loop.

00:19 Insert and design UserForm1 (set duration)
02:03 Add numbers to combo box
05:41 Insert and design UserForm2 (Timer)
07:35 Transfer values from UserForm1 to UserForm2
08:59 Instruction to "Start", "Resume", "Pause" or "Stop"
10:49 Condition to update or terminate the timer
12:18 Code to change the width and the color of HP bar
14:42 Terminating the timer
14:51 Create a public variable (dummy)
15:12 Insert command button on sheet to call UserForm1
15:27 Result

To run the timer in the background 👉 How to edit Excel file while macro is...

Functions/Properties:
1. For Each ... Next
2. TypeName
3. Format
4. Caption
5. BackColor
6. ForeColor
7. Application.Wait
8. Visible
and more ...

Ready-to-use file for free download (only for end use) 👉 Facebook: 768148264642385
File password 👉 AhSingCountdown

Excel & VBA discussion public group 👉 Facebook: 486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗

#excel  #vba