Excel Worksheet Events #2 Macro when you change a cells value, LEFT and UCASE functions

Опубликовано: 04 Октябрь 2024
на канале: ExcelVbaIsFun

67,048

280

📊 Free Workbooks: https://www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

Learn how to trigger a macro or code when the user changes a cell's value, whether it's any cell or a specific cell(s).
We also use VBA's native Left() and UCase() functions to get the first letter of a name and run a macro if the first letter is "M" or "P". Fun!!!

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/