Learn How to Create a One-Click Dynamic Checklist in Microsoft Excel using some simple lines of VB (Visual Basic) and some conditional formatting and cool fonts.
-------- S O L U T I O N S
✔️ Using one line of VB (Visual Basic) code and conditional formatting
-------- P R E V I O U S V I D E O
⏮️ TURN ON the CELL WIDTH AUTOFIT on MICROSOFT EXCEL
🔗 • Autofit Cell Width | Microsoft Excel
-------- C R E D I T S T O M U S I C
🎵 Royalty Free Music by PixBay: https://www.pixbay.com/
-------- S U B S C R I B E
❤️ DON'T forget to LIKE, COMMENT your IDEA, and SUBSCRIBE
🔗 https://bit.ly/3Pakd48
-------- I N S T A G R A M
📷 / atrin_noori
--------- W I N D O W S T I P S & T R I C K S E P I S O D E 1 6 ---------
00:00 - Learn How to CREATE a DYNAMIC CHECKLIST in MICROSOFT EXCEL
00:20 - Visual Basic code breakdown
01:37 - Part Two: Table Boundary limit check
01:57 - Part Two: Visual Basic Code to limit table boundaries
02:13 - Part Three: Conditional formatting
03:11 - Part Three: Rule Application on table range
03:27 - Part Four: Custom font and Alignment
03:45 - End Screen
--------- A B O U T S E C T I O N ---------
🙍 About Microsoft Windows:
Windows is a group of several proprietary graphical operating system families developed and marketed by Microsoft. Each family caters to a certain sector of the computing industry. For example, Windows NT for consumers, Windows Server for servers, and Windows IoT for embedded systems
🙍 About Microsoft Office:
Microsoft Office, or simply Office, is a discontinued family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas.
🙍 About Microsoft Excel:
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft 365 suite of software