How to Compare 2 Lists using Excel VBA44

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=P_UVvYW2xto

👉 Ready to master VBA? • Check out my full courses: https://courses.excelmacromastery.com/ • Subscribe to the channel here: https://bit.ly/36hpTCY • Want to download the source code for this video? Go here: https://bit.ly/3mLpu5W • (Note: If the download page doesn't work then make sure to turn off any popup blockers) • How to Compare 2 Lists using Excel VBA • This video is the 4th in the Excel VBA Dictionary series. • In this video we look at another real-world example that can be solved using the dictionary. • The task is to compare 2 lists of data and to return one of three results: • 1. All items in list 1 only. • 2. All items in list 2 only. • 3. All items both lists. • In video I show you how to design a simple application to provides the result you specify. It full of proven techniques used by professional programmers. • • Useful VBA Shortcut Keys: • Shift + F2: Get the definition of the item under the cursor. • Ctrl + Shift + F2: Go to the last cursor position. • Ctrl + Space: AutoComplete Word. • Alt + F11: Switch between Excel and the VBA Editor. • Ctrl + R: View the Project Explorer Window. • F4: View the Properties Window. • F5: Run the code from the current sub. • F9(or click left margin): Add a breakpoint to pause the code. • Tab: To move lines of code to the right(Indent). • Shift + Tab: To move lines of code to the left(Outdent).

#############################

New on site