Premium Only Content

Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)
Aug 23, 2018 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
Quickly learn how to work with Excel VBA IF, THEN, ELSE, ELSEIF, AND statements. This way you can write Excel macros that are dependent on multiple conditions.
We take a look at looping through a set range of cells in an Excel table, checking their value and then changing the cell color based on that value.
In addition to learning the IF THEN statement and how to loop through cells, you also learn how to quickly get the color code of a specific cell so you can refer to it in your Excel macro. I'll show you a trick with the immediate window and how you can test, and query code in there.
🡻 Download the workbook here 🡻
https://www.xelplus.com/excel-vba-if-then-elseif-statement/
★ Links to related videos: ★
FOR EACH VBA: https://youtu.be/5bq3N99mNPE
IF THEN in Excel Formulas: https://youtu.be/KkTaQ5OjAGc
VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★★ My Online Excel Courses including VBA ★★
Courses ► https://courses.xelplus.com/
🕮 Excel Resources I Recommend 🕮
https://www.xelplus.com/resources/
✉ Subscribe & get my Excel top 10 tips and formulas e-book for free
https://www.xelplus.com/free-ebook/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #ExcelVBA #LeilaGharani
-
1:08:36
Man in America
16 hours agoUS, China, Israel & the Battle for the New World Order w/ Boone Cutler
98.7K80 -
2:37:49
The Connect: With Johnny Mitchell
1 day ago $10.14 earnedBlackwater Mercenary EXPOSES Private Military War Secrets From The Middle East, Fueling Terrorism
42.7K43 -
LIVE
EXPBLESS
1 hour agoA Rare Sunday Morning Stream (Hunt: Showdown LIVE Gameplay)
507 watching -
2:54:21
Total Horse Channel
2 days ago2025 Scottsdale Arabian Horse Show | Saturday Evening Session
87.3K6 -
LIVE
BigDaddySlick78's Live Gaming Channel
4 hours ago🔴 Call Of Duty Warzone Rebirth Island & Area 99 Live w/ Subs #callofduty #warzone #bo6 #cod
97 watching -
22:39
The Mel K Show
12 hours agoMel K & Representative Brandon Gill | Our Constitutional Republic is Being Restored | 4-26-25
63.4K53 -
4:17:17
VapinGamers
12 hours ago $6.78 earned📣 Fortnite Family Night! - Games and Dubs with BrianZGame - !rumbot
61.7K4 -
4:27:48
ThePope_Live
10 hours agoLIVE - First time playing The Finals in over a YEAR! Still good? with @Arrowthorn
46.6K1 -
3:06:26
TruthStream with Joe and Scott
16 hours agoRoundtable with Patriot Underground and News Treason Live 4/26 5pm pacific 8pm Eastern
75.7K41 -
8:52
Tundra Tactical
14 hours ago $10.62 earnedSCOTUS Denies Appeal, Minnesota Courts Deal 2a Win!
68.3K13