Excel VBA Tips n Tricks 37 Using SELECT CASE instead of IF THEN Pt 4 CASE IS Using Operators

2,919 views · Published 16 June 2013 · 3:17 · Indexed 29 September 2026

Channel: ExcelVbaIsFun · 2013 · Education

Watch on YouTube

📊 Free Workbooks: https://www.excelvbaisfun.com/links?utm_source=youtube&utm_medium=desc&utm_content=dkjrxGyqR-M
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapro🔥(2 Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

Here's how to use operators in your Select Case code, to compare things. Operators include:

Greater than, greater than equal to, less than, less than equal to, equal to, not equal to. For some reason i can't put these symbols, youtube is calling this an illegal character. . .

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

More from this channel