How to Compare 2 Lists using Excel VBA(4/4)
51.7 هزار بار بازدید -
5 سال پیش
-
👉 Ready to master VBA?-
👉 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).
- 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).
5 سال پیش
در تاریخ 1398/07/11 منتشر شده
است.
51,718
بـار بازدید شده