Excel VBAの基礎とTips, Eventの使い方について勉強できるYoutube動画
Excel VBAの基礎とTips, Eventの使い方について勉強できる動画。（英語）
Excel VBAの基礎：
1. Excel VBA Basics #1 - Getting started with Range object, running and debugging
https://www.youtube.com/watch?v=AIhKN...
2. Excel VBA Basics #2 - Using the Cells object with and without range object, named ranges
https://www.youtube.com/watch?v=iy0v0...
3. Excel VBA Basics #3 - Using For and Next with variable, using loops for custom reporting
https://www.youtube.com/watch?v=E6wtx...
4. Excel VBA Basics #4 - IF THEN statements within the FOR NEXT loop
https://www.youtube.com/watch?v=hS6yC...
5. Excel VBA Basics #5 - Toolbars, Messageboxes, Object Browser, Autocomplete and Code Windows
https://www.youtube.com/watch?v=NqDCC...
6. Excel VBA Basics #6 - Fun with the Immediate Window
https://www.youtube.com/watch?v=b4qWv...
7. Excel VBA Basics #7 - Using specific sheets, Hiding, Unhiding and Selecting with VBA
https://www.youtube.com/watch?v=f1LET...
8. Excel VBA Basics #8 - Find the LAST ROW or COLUMN dynamically and clearing out your last report
https://www.youtube.com/watch?v=K0Vqy...
9. Excel VBA Basics #9 - Declaring variables with DIM and using SET to abbreviate worksheet name
https://www.youtube.com/watch?v=S55cK...
10. Excel VBA Basics #10 - Looping through a database and analyzing cells based on criteria
https://www.youtube.com/watch?v=JEVh3...
11. Excel VBA Basics #11 Create your Own Custom Functions with or without Arguments
https://www.youtube.com/watch?v=uh409...
12. Excel VBA Basics #12 Custom Functions - Making VLOOKUP Even Easier for Coworkers
https://www.youtube.com/watch?v=lU-I0...
13. Excel VBA Basics #13 Switching Between Workbooks Dynamically, Create New Workbooks
https://www.youtube.com/watch?v=1iiJL...
14. Excel VBA Basics #14 QnA How to Combine Several Workbooks into ONE using VBA
https://www.youtube.com/watch?v=HmAYK...
15. Excel VBA Basics #15 How to Use GOTO to Jump Around Your Macro
https://www.youtube.com/watch?v=cE1NO...
16. Excel VBA Basics #16A ERRORS - Custom Code On Error, Using GOTO Labels
https://www.youtube.com/watch?v=kwvZL...
17. Excel VBA Basics #16B ERRORS - Continue your macro Even with Errors Using On Error Resume Next
https://www.youtube.com/watch?v=DD4Iv...
18. Excel VBA Basics #16C ERRORS - Determine If There Was An Error, Which Type, and Define What To Do
https://www.youtube.com/watch?v=kCJeU...
19. Excel VBA Basics #17 To Declare Variable or Not To Declare - How To NOT HAVE TO DIM All Variables
https://www.youtube.com/watch?v=Egf02...
20. Excel VBA Basics #18 - Change the Font Type, Size etc using VBA!
https://www.youtube.com/watch?v=fvVhO...
21. Excel VBA Basics #19 Using VLOOKUP in VBA
https://www.youtube.com/watch?v=m-La7...
22. Excel VBA Basics #19 Using VLOOKUP in VBA - Alternate Method
https://www.youtube.com/watch?v=JRV-a...
23. Excel VBA Basics #20 Using VLOOKUP in VBA for a Custom Message
https://www.youtube.com/watch?v=4VKp_...
24. Excel VBA Basics #21 Put VLOOKUP info in StatusBar using Application.Statusbar
https://www.youtube.com/watch?v=ImCZy...
25. Excel VBA Basics #21a Restore StatusBar to Normal - Simple!
https://www.youtube.com/watch?v=wAqHS...
26. Excel VBA Basics #22 SumIfs Using VBA
https://www.youtube.com/watch?v=N-tDB...
27. Excel VBA Basics #23 DATEADD - Add or Subtract Minutes, Months, Weekdays, Seconds whatever!!
https://www.youtube.com/watch?v=mM5It...
28. Excel VBA Basics #24 DateDiff in VBA - Difference in Seconds, Hours, Weekdays, Quarters, Months, Etc
https://www.youtube.com/watch?v=3Apri...
29. Excel VBA Basics #25 Extract the DAY, WEEKDAY, MONTH, YEAR from a date. How to use DateSerial
https://www.youtube.com/watch?v=6sX_N...
30. Excel VBA Basics #26 WeekdayName and MonthName in VBA
https://www.youtube.com/watch?v=1hkkj...
31. Excel VBA Basics #29 How to Use ME in Excel VBA (me dot object variable)
https://www.youtube.com/watch?v=yzcg6...
32. Excel VBA Basics #30 How to Loop Through Each Worksheet in Workbook
https://www.youtube.com/watch?v=-75HK...
33. Excel VBA Basics #31 Send Sheets Straight to Printer using PrintOut Method
https://www.youtube.com/watch?v=lOg6-...
34. Excel VBA Basics #32 Create Sample Database Almost Instantly
https://www.youtube.com/watch?v=_UxBr...
35. Excel VBA Basics #33 Importance of Naming Column Variables for Reports
https://www.youtube.com/watch?v=wygd_...
36. How to Speed Up Your Workbook - My SECRET EXCEL WEAPON
https://www.youtube.com/watch?v=DsJOv...
37. How to Put Data in Specific Sheets and Not on Active sheet
https://www.youtube.com/watch?v=3f722...
38. How to Massively Speed Up Your Workbook and Make Macros Run Faster - Excel VBA Is Fun
https://www.youtube.com/watch?v=PhbB6...
39. How to Fill Comboboxes (DropDowns) In Userforms or Worksheets - BOTH WAYS! Excel VBA Is Fun
https://www.youtube.com/watch?v=eCvBv...
40. Count and CountA in VBA Excel
https://www.youtube.com/watch?v=adIW3...
41. CountIF Excel VBA
https://www.youtube.com/watch?v=9kpst...
42. For Next Loop with Dates - Excel VBA
https://www.youtube.com/watch?v=gfMaa...
43. Find the Next Available Row In Excel VBA - Simple 2 min!!
https://www.youtube.com/watch?v=egYkG...
44. Auto-Hide Your Worksheet When You Click Away! Excel VBA
https://www.youtube.com/watch?v=z8BHx...
45. Loop Through a Named Range in Excel VBA
https://www.youtube.com/watch?v=629dq...
46. SUBTOTAL in Bottom Cell using Excel VBA
https://www.youtube.com/watch?v=_ZFx3...
47. Eliminate VBA Vlookup Errors - Excel VBA Tips - Error 1004 No More!
https://www.youtube.com/watch?v=2a3c4...
48. Change MultiPage Tabs to Left, Right, Top or Bottom - Easy! Excel VBA
https://www.youtube.com/watch?v=T4yGF...
Tips：
1. Excel VBA Tips n Tricks #1 Bold, Underline, Italic using VBA
https://www.youtube.com/watch?v=Z08z5...
2. Excel VBA Tips n Tricks #2 Have Excel SELECT Specific Cell or Cell Relative to Selection
https://www.youtube.com/watch?v=qOH0H...
3. Excel VBA Tips n Tricks #3 Most powerful function in Excel Visual Basic - The EVALUATE Formula
https://www.youtube.com/watch?v=CdQJq...
4. Excel VBA Tips n Tricks #4 Set up a Temporary Range for your Macro!
https://www.youtube.com/watch?v=RrgHF...
5. Excel VBA Tips n Tricks #5 Fill a List From Non-Blank Cells - Going Down OR Over
https://www.youtube.com/watch?v=chovI...
6. Excel VBA Tips n Tricks #5a Fill a List From Non-Blank Cells - Going Down OR Over with NAMED RANGE
https://www.youtube.com/watch?v=kKzJl...
7. Excel VBA Tips n Tricks #6 How to not overwrite your column headers - FAILSAFE
https://www.youtube.com/watch?v=QLq6J...
8. Excel VBA Tips n Tricks #7 Custom Keyboard shortcuts using Application.Onkey method
https://www.youtube.com/watch?v=MbHYJ...
9. Excel VBA Tips n Tricks #8 Custom Function - NINJA NAME Looks up your name and finds your Ninja name
https://www.youtube.com/watch?v=7OmKV...
10. Excel VBA Tips n Tricks #9 Quickly Locate Any Macro, UDF or Worksheet Event - TIP
https://www.youtube.com/watch?v=2st7h...
11. Excel VBA Tips n Tricks #10 How To Remove a Module in VBA Editor
https://www.youtube.com/watch?v=1Z1O7...
12. Excel VBA Tips n Tricks #11 Find the Pay Period Start Date and End Date - Easy!
https://www.youtube.com/watch?v=KTdrD...
13. Excel VBA Tips n Tricks #11B Pay Period Start and End Date - CUSTOM FUNCTION
https://www.youtube.com/watch?v=YPGcx...
14. Excel VBA Tips n Tricks #12 NO MORE COLONS When Typing Time of Day, Type 123 instead of 01colon23 AM
https://www.youtube.com/watch?v=ATxaN...
15. Excel VBA Tips n Tricks #13 Logo or Splash Screen that goes away after a few seconds!!
https://www.youtube.com/watch?v=e0c8z...
16. Excel VBA Tips n Tricks #14 Hiding Worksheets - xlHidden versus xlVeryHidden
https://www.youtube.com/watch?v=sqKjC...
17. Excel VBA Tips n Tricks #15 Converting Jumbled Data to WORKABLE Data for Reporting
https://www.youtube.com/watch?v=-_oVV...
18. Excel VBA Tips n Tricks #16 Make a Calendar in Excel VBA
https://www.youtube.com/watch?v=Q3prc...
19. Excel VBA Tips n Tricks #17 Highlight Selected Row or Column
https://www.youtube.com/watch?v=jm6wl...
20. Excel VBA Tips n Tricks #18 Stopwatch in Excel
https://www.youtube.com/watch?v=ZkblA...
21. Excel VBA Tips n Tricks #19 MkDir VBA Function Make folders and subfolders using excel
https://www.youtube.com/watch?v=ZDVfF...
22. Excel VBA Tips n Tricks #20 Random Names Generator
https://www.youtube.com/watch?v=oToMK...
23. Excel VBA Tips n Tricks #21 Control Charts with VBA
https://www.youtube.com/watch?v=fNEeQ...
24. Excel VBA Tips n Tricks #21a Things you can do with Charting in reports ideas
https://www.youtube.com/watch?v=Lt-qo...
25. Excel VBA Tips n Tricks #22 Rename Charts and Select Any Chart
https://www.youtube.com/watch?v=vJQr5...
26. Excel VBA Tips n Tricks #23 Unprotect and Protect, Passwords and Features
https://www.youtube.com/watch?v=8ukNV...
27. Excel VBA Tips n Tricks #24 Manage Long VBA Sentences using Underscore
https://www.youtube.com/watch?v=O0ocq...
28. Excel VBA Tips n Tricks #25 Comparing TextBox Dates in Worksheet Loop User Q n A
https://www.youtube.com/watch?v=JgXTL...
29. Excel VBA Tips n Tricks #26 How to Use Complicated Sequence or Serial Numbers User Q n A
https://www.youtube.com/watch?v=6OFmI...
30. Excel VBA Tips n Tricks #27 Viewer Made Random Names Generator Awesome Job!
https://www.youtube.com/watch?v=t3YCU...
31. Excel VBA Tips n Tricks #28 Rotate Color of Cell each time you Click User Q n A
https://www.youtube.com/watch?v=tuJIF...
32. Excel VBA Tips n Tricks 30 Best Practices with Cell Referencing and Concatenation with Ampersand
https://www.youtube.com/watch?v=h9zpa...
33. Excel VBA Tips n Tricks 31 Google Drive - Making a Form and Collecting Data Online
https://www.youtube.com/watch?v=5K3gx...
34. Excel VBA Tips n Tricks 32. Different Columns Every Day - Sort, Change Headers and Color Dynamically
https://www.youtube.com/watch?v=bJ-6h...
35. Excel VBA Tips n Tricks 33 VLookup Troubleshooting in VBA User Q n A
https://www.youtube.com/watch?v=pmY2W...
36. Excel VBA Tips n Tricks 33 Custom Print Area
https://www.youtube.com/watch?v=nTGZu...
37. Excel VBA Tips n Tricks 34 Google Drive Follow Up Results to Our Form NEATO!
https://www.youtube.com/watch?v=XDlEA...
38. Excel VBA Tips n Tricks 34 Using SELECT CASE instead of IF THEN Pt 1
https://www.youtube.com/watch?v=VMlnD...
39. Excel VBA Tips n Tricks 35 Using SELECT CASE instead of IF THEN Pt 2 IF This OR That
https://www.youtube.com/watch?v=R4ExT...
40. Excel VBA Tips n Tricks 36 Using SELECT CASE instead of IF THEN Pt 3 From This to That
https://www.youtube.com/watch?v=vTugA...
41. Excel VBA Tips n Tricks 37 Using SELECT CASE instead of IF THEN Pt 4 CASE IS Using Operators
https://www.youtube.com/watch?v=dkjrx...
42. Excel VBA Tips n Tricks 38 Using SELECT CASE instead of IF THEN Pt 5 Using AND with Select Case
https://www.youtube.com/watch?v=FTUUg...
43. Example of Cool Programs YOU CAN WRITE - Rental Management Program
https://www.youtube.com/watch?v=f1jTF...
44. Excel VBA Tips n Tricks 40 Problems When Finding Dynamic Column to Sort What If It's Gone Q n A
https://www.youtube.com/watch?v=Uzj5H...
45. Excel VBA Tips n Tricks 41 Referencing Named Range from Other Workbook Q n A
https://www.youtube.com/watch?v=ad8P2...
46. Excel VBA Tips n Tricks 42 Put info on Userform and Save it to the Hidden Datasheet Q n A
https://www.youtube.com/watch?v=w1hTv...
47. Excel VBA Tips n Tricks 43 Worship Team Scheduler Tool Project - Part 1
https://www.youtube.com/watch?v=cml9h...
48. Excel VBA Tips n Tricks 44 MsgBox with or without Parenthesis - User Q n A
https://www.youtube.com/watch?v=GjwAU...
49. Excel VBA Tips n Tricks 45 Close Workbook if Password Fails 3 Times
https://www.youtube.com/watch?v=nFpkY...
50. Excel VBA Tips n Tricks 46 How to Use InputBox
https://www.youtube.com/watch?v=OOc-G...
51. Excel VBA Tips n Tricks 47 Custom Function Phone Number Function to Add Spaces, Hyphens and Parent
https://www.youtube.com/watch?v=uwApI...
52. How to Speed Up Your Workbook - My SECRET EXCEL WEAPON
https://www.youtube.com/watch?v=DsJOv...
53. FREE Credit Card Expense Tally Sheet with AutoSummed Categories - PLUS How to - a Hint of VBA
https://www.youtube.com/watch?v=k1rZl...
54. Excel VBA TnT 48 Interesting Incrementing Rule Macro 123 124 125 126 127 128 134 etc
https://www.youtube.com/watch?v=Ca6jy...
55. Excel VBA TnT 49 INDIRECT Alternative Fill Combobox with different Ranges
https://www.youtube.com/watch?v=0QDbi...
56. How to Hide Excel and Show Userform ONLY - Excel VBA
https://www.youtube.com/watch?v=3nlJu...
57. Make Images Look and Feel Like Buttons on your Userform Excel VBA
https://www.youtube.com/watch?v=UTFnE...
58. How to Write on Word from Excel using VBA
https://www.youtube.com/watch?v=-2oPx...
59. Generate a Corn Field Assessors Map - Custom Report
https://www.youtube.com/watch?v=fpAGc...
60. Troubleshoot Variables Not Showing up on Mouseover Hover - Excel VBA
https://www.youtube.com/watch?v=thmld...
61. Generate a Corn Field Assessors Map - Custom Report Pt 2 - Different Assessment pages
https://www.youtube.com/watch?v=wmHGc...
62. Automate Manual Filtering and Reporting - Eliminate Redundant Tasks with VBA 56 MINUTES
https://www.youtube.com/watch?v=2Ambz...
63. How to Make Comboboxes Disappear, Use MultiColumn Listbox and Track Records on Userform Q n A
https://www.youtube.com/watch?v=-Y7AY...
64. How to Increment Letters and Number Combinations LTS0001 becomes LTS0002 etc
https://www.youtube.com/watch?v=vGguM...
65. Corn Assessor's Excel VBA Program - Follow Up - FINISHED
https://www.youtube.com/watch?v=pMUP1...
66. How to Import Text (.txt) Files Into Excel - Excel VBA Tutorial - Awesome!!
https://www.youtube.com/watch?v=SwN5v...
67. VBA Match versus .Worksheetfunction Match - Excel VBA Is Fun!
https://www.youtube.com/watch?v=PD5cg...
68. Get Unique Items in Combo Box - 2 Methods - User Q n A
https://www.youtube.com/watch?v=1HH5i...
69. How to Email Your Current Workbook in Excel VBA
https://www.youtube.com/watch?v=0xnk-...
70. How to Filter Combobox From Another Combobox - Cascading Comboboxes
https://www.youtube.com/watch?v=yMO_w...
71. Eliminate Flashing when Running Macro in Excel VBA - Tips n Tricks
https://www.youtube.com/watch?v=edWL7...
72. Dynamically Add New Checkbox and Rename the Caption - Excel VBA
https://www.youtube.com/watch?v=RS48W...
73. Fill Multiple Listboxes, Get Payments to Date, INVOICE Balances Dynamically! - Excel VBA
https://www.youtube.com/watch?v=EzRwY...
74. Open Hyperlinks in Firefox, Chrome, Internet Explorer Excel VBA Tricks
https://www.youtube.com/watch?v=Spmhy...
75. How to SUM Totals At Bottom of a Column Dynamically - Excel VBA Is Fun!
https://www.youtube.com/watch?v=_0Vcn...
76. Lookup in VBA Table Without LOOPS - Excel VBA Is Fun
https://www.youtube.com/watch?v=3ky1C...
77. How to Find the Last Row of ALL Columns in UsedRange
https://www.youtube.com/watch?v=_XZDJ...
78. Run Time Error 1004 Help in Excel VBA - Scott's Job Tracker
https://www.youtube.com/watch?v=_96X_...
79. How to Format LinkedCell TextBoxes the Easy Way! Excel VBA
https://www.youtube.com/watch?v=_8rxf...
80. How to Use LinkedCell for Textboxes and Checkboxes in a Worksheet
https://www.youtube.com/watch?v=w3ljS...
81. SUM of two or more Textboxes and Tricks to Automate This - Excel VBA
https://www.youtube.com/watch?v=UnnZg...
82. How to Prevent Userform From Closing Until You Want It to Close
https://www.youtube.com/watch?v=uzKyj...
83. How to Sort Comboboxes Ascending or Descending, Numbers or Text using VBA - FREE DOWNLOAD!!
https://www.youtube.com/watch?v=yP0B1...
84. Populate Internet Textbox, Fill Forms, click Submit using Excel
https://www.youtube.com/watch?v=GswfT...
85. Populate and Click on Internet Explorer Windows Already Open Using Excel VBA
https://www.youtube.com/watch?v=mVBgF...
86. Runtime Error '424' Object Required Error Vlookup Help - ExcelVbaIsFun QnA
https://www.youtube.com/watch?v=Iyjvb...
87. How to Make Pretty Userform Buttons with Pictures
https://www.youtube.com/watch?v=1Vs6F...
88. How to Make Pretty Userform Buttons with Pictures and Text Buttons pt 2
https://www.youtube.com/watch?v=y15lh...
89. How to Create a Shared Dropbox Folder - Sync files to Everybody Instantly Update Your Team!
https://www.youtube.com/watch?v=pIEVZ...
90. Use Command Button to Navigate Your Workbook Like a Hyperlink
https://www.youtube.com/watch?v=wjnIz...
91. Last Cell Highlighted in Excel
https://www.youtube.com/watch?v=nJBwg...
92. Autocalculate Best Combo of Rates for Vehicles - Q n A
https://www.youtube.com/watch?v=EkT6U...
93. Format Phone Numbers in Excel VBA - Different Macro per Column
https://www.youtube.com/watch?v=_TkxC...
94. CountIFS in Excel VBA
https://www.youtube.com/watch?v=AIkrB...
95. Hide and Unhide Textbox, Manipulate data, Save File In Predetermined Location - EXCEL VBA!
https://www.youtube.com/watch?v=jQ9vz...
96. Embed Shockwave Flash in Excel - Livio's Example
https://www.youtube.com/watch?v=BxaVK...
97. CountIFS with Dates - Excel VBA
https://www.youtube.com/watch?v=iHBXi...
98. Copy Facebook Contacts to LinkedIn - Easy! 2 Minutes
https://www.youtube.com/watch?v=wHfnu...
99. How to Cancel Print Job (if it's not legal paper) in Excel VBA
https://www.youtube.com/watch?v=g2pZC...
100. Make Excel Speak and Read Outloud - Excel VBA
https://www.youtube.com/watch?v=nDaXp...
Eventの使い方：
1. Excel Worksheet Events #1 Macro when you change cells OR select specific cells
https://www.youtube.com/watch?v=ZnnCm...
2. Excel Worksheet Events #2 Macro when you change a cells value, LEFT and UCASE functions
https://www.youtube.com/watch?v=TpP9_...
3. Excel Worksheet Events #3 Double click,Change formats based on cell values when double clicked
https://www.youtube.com/watch?v=gNaLz...
4. Excel Worksheet Events #4 RightClick,Open + fill Userform on R-click, disable right click menu
https://www.youtube.com/watch?v=Ns3M1...
5. Excel VBA Events #5 Worksheet Activate-Select sheet, type age, inputbox puts it in bottom cell
https://www.youtube.com/watch?v=FJMIT...
6. Excel VBA Events #6 - Worksheet Deactivate - Hide current sheet when you select another sheet
https://www.youtube.com/watch?v=EOJoq...
7. Excel VBA Events #7 Workbook Events - Run code when you print, save, open or close workbooks etc
https://www.youtube.com/watch?v=vMNW5...
8. Format Phone Numbers in Excel VBA - Different Macro per Column
https://www.youtube.com/watch?v=_TkxC...
9. How to Cancel Print Job (if it's not legal paper) in Excel VBA
https://www.youtube.com/watch?v=g2pZC...
10. How to Avoid Infinite Loops - Disable Events in Excel VBA
https://www.youtube.com/watch?v=Wf7ci...
11. Disable Items from Right Click Menu in Excel VBA
https://www.youtube.com/watch?v=BVS3y...
  |
