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...
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) 👉 / 768148264642385
File password 👉 AhSingCountdown
Excel & VBA discussion public group 👉 / 486402069483674
Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗
#excel #vba
Негізгі бет Countdown timer with HP bar on UserForm
Пікірлер: 7