Excel VBA Basics #9 - Declaring variables with DIM and using SET to abbreviate worksheet name

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

177,966

934

📊 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)

In this video, we learn how to tell Excel what type of variable we're using, and then it gives us feedback by allowing autofill dropdowns and giving previews of values. Setting an object, such as a worksheet, to be abbreviated to a shortened name will save you a lot of extra typing also. Download wb: http://excelvbaisfun.com/mdocs-posts/...

🔒 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/