One Click Dynamic Checklist | Microsoft Excel

Опубликовано: 04 Ноябрь 2024
на канале: How To 365
114
1

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