読者です 読者をやめる 読者になる 読者になる
スポンサーリンク

Excel VBAで,ユーザーフォームとActive Xについて勉強できるYoutube動画

VBA excel Youtube

Excel/Wordオフィス製品のTipsまとめへ


Excel VBAで,ユーザーフォームとActive Xについて勉強できる動画。(英語)


ユーザーフォームについての動画:

1. Excel VBA USERFORMS #1 Make Userform, Add a Button, Button Click Hides Form
https://www.youtube.com/watch?v=E6MQd...


2. Excel VBA USERFORMS #2 Sort Database By Employee Id or Name - User Chooses Using Optionbuttons!
https://www.youtube.com/watch?v=6Ju6B...


3. Excel VBA USERFORMS #3 Custom Code When Userform Loads/Initializes, Fill Combobox Dynamically
https://www.youtube.com/watch?v=rdetE...


4. Excel VBA USERFORMS #4 Load Combobox by Employee ID or Name using Option Buttons
https://www.youtube.com/watch?v=ZoGoj...


5. Excel VBA USERFORMS #5 Include Or Exclude Inactive Employees In Dropdown List Dynamically
https://www.youtube.com/watch?v=w7zrl...


6. Excel VBA USERFORMS #6 Add a Label to Your Userform - Employee ID Number In Label
https://www.youtube.com/watch?v=hdllt...


7. Excel VBA USERFORMS #7 Lookup Status and Favorite Color on Combobox Click!
https://www.youtube.com/watch?v=KJJcr...


8. Excel VBA USERFORMS #8 Using IIf Function in VBA - Easier!
https://www.youtube.com/watch?v=acfvr...


9. Excel VBA USERFORMS #9 Running Our First REPORT - Dynamically from Userform!!
https://www.youtube.com/watch?v=IDHuL...


10. Excel VBA USERFORMS #10 Open Userform From Image, Create a Home Page
https://www.youtube.com/watch?v=cJ5nn...


11. Excel VBA USERFORMS #11 Automatically Unhide and Select Sheet When Report Is Run
https://www.youtube.com/watch?v=PvqAQ...


12. Excel VBA USERFORMS #12 Create A Neat, Tidy HOME Page Worksheet
https://www.youtube.com/watch?v=dZlp_...


13. Excel VBA USERFORMS #13 Create A Print Preview Checkbox On Userform for Our Employee Report
https://www.youtube.com/watch?v=X4QBS...


14. Excel VBA USERFORMS #14 Auto-Close Report After User Prints or Views Report
https://www.youtube.com/watch?v=s4FhS...


15. Excel VBA USERFORMS #15 Select And Edit Sheets with Userform Still Open!
https://www.youtube.com/watch?v=yglyB...


16. Excel VBA USERFORMS #16 Auto Format Dates in Textbox
https://www.youtube.com/watch?v=2K_Zl...


17. Excel VBA USERFORMS #17 Increase and Decrease Dates in Textbox with Spinbutton
https://www.youtube.com/watch?v=6r4w5...


18. Excel VBA USERFORMS #18 Make a WIZARD in Excel - Next, Back and Finish Buttons
https://www.youtube.com/watch?v=icLTc...


19. Excel VBA USERFORMS #19 Viewer Made Auto-Calendar with Nice Borders
https://www.youtube.com/watch?v=QuHf3...


20. Excel VBA USERFORMS #20 Data Entry a Breeze with Userforms! AUTOCOMPLETE with Combobox
https://www.youtube.com/watch?v=b6GJZ...


21. Excel VBA Tips n Tricks #25 Comparing TextBox Dates in Worksheet Loop User Q n A
https://www.youtube.com/watch?v=JgXTL...


22. Excel VBA USERFORMS #24 Calendar Date Picker Tool Teaser Demo
https://www.youtube.com/watch?v=NDHjK...


23. Excel VBA USERFORMS #21 Use the Mouse Scroll Wheel for Listbox! Example included
https://www.youtube.com/watch?v=j3FME...


24. Excel VBA USERFORMS #22 Use the Mouse Scroll Wheel for Combobox! Example included
https://www.youtube.com/watch?v=UG7AW...


25. Excel VBA USERFORMS #23 Use the Mouse Scroll Wheel without changing selection Example included
https://www.youtube.com/watch?v=R3rel...


26. Excel VBA USERFORMS #24 Using ME CONTROLS) in VBA Looping though objects controls!!
https://www.youtube.com/watch?v=rEF4l...


27. Excel VBA USERFORMS #25 Date Picker Calendar revealed! Loop through Userforms and Controls Example
https://www.youtube.com/watch?v=yQw73...


28. Example of Cool Programs YOU CAN WRITE - Rental Management Program
https://www.youtube.com/watch?v=f1jTF...


29. 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...


30. How to Hide Excel and Show Userform ONLY - Excel VBA
https://www.youtube.com/watch?v=3nlJu...


31. Make Images Look and Feel Like Buttons on your Userform Excel VBA
https://www.youtube.com/watch?v=UTFnE...


32. How to Prevent Userform From Closing Until You Want It to Close
https://www.youtube.com/watch?v=uzKyj...


33. How to Sort Comboboxes Ascending or Descending, Numbers or Text using VBA - FREE DOWNLOAD!!
https://www.youtube.com/watch?v=yP0B1...


34. How to Make Pretty Userform Buttons with Pictures
https://www.youtube.com/watch?v=1Vs6F...


35. How to Make Pretty Userform Buttons with Pictures and Text Buttons pt 2
https://www.youtube.com/watch?v=y15lh...


36. Print Specific Sheets from Userform Checkboxes - User Q n A
https://www.youtube.com/watch?v=TRYek...


37. Print Specific Sheets from Userform Checkboxes PRINTPREVIEW METHOD - User Q n A pt 2
https://www.youtube.com/watch?v=NmXoY...


38. How to Create 3 Column Listbox on Worksheet or Userform in Excel VBA
https://www.youtube.com/watch?v=pCuTg...


39. New Program Example in Excel VBA - Church Attendance Tool! Awesome
https://www.youtube.com/watch?v=iii-2...


40. Increase or Decrease Textbox by One using Spinbuttons
https://www.youtube.com/watch?v=OWrj8...


41. Increase or Decrease Textbox by One using Spinbuttons (Less Squinty Version)
https://www.youtube.com/watch?v=bPtWj...


42. Inventory System 101 In Excel VBA a Step by Step Guide to the Basics
https://www.youtube.com/watch?v=b75zE...


43. Fill Userform with Worksheet Data EASILY - User Q n A
https://www.youtube.com/watch?v=xuaMG...


44. Bout Statistics Logger for Roller Derby - Excel VBA
https://www.youtube.com/watch?v=uIqB3...


45. Disable Typing Over ComboBox Items - List Only in ComboBox in Excel VBA Dropdown
https://www.youtube.com/watch?v=o0rBn...


46. Two Comboboxes VBA Userform - One Controls the Other - Excel VBA Is Fun
https://www.youtube.com/watch?v=qvakb...


47. Kevin Carter's Golf Tournament Director Program in Excel VBA - WOW! Great Date Picker!!
https://www.youtube.com/watch?v=vgpTQ...


48. Grant's Error on Submitting His Userform - Data Entry Question
https://www.youtube.com/watch?v=0i7wO...


49. Filter ComboBox by Textbox Value Using Enter Key - FranchiseBall Excel Program Feature Keydown
https://www.youtube.com/watch?v=qUYoM...


50. Eliminate VBA Vlookup Errors - Excel VBA Tips - Error 1004 No More!
https://www.youtube.com/watch?v=2a3c4...


51. Change MultiPage Tabs to Left, Right, Top or Bottom - Easy! Excel VBA
https://www.youtube.com/watch?v=T4yGF...


52. Pull Up Photos Dynamically on a Userform - Great For Employee or Product Maintenance Form
https://www.youtube.com/watch?v=jnbg4...


ActiveX コントロールについての動画:

1. Excel VBA ActiveX Controls #1 Worksheet Button and Textbox
https://www.youtube.com/watch?v=EZZ8e...


2. Excel VBA ActiveX Series #2 Checkbox, Changing cell value on click, and background color!
https://www.youtube.com/watch?v=zOq58...


3. Excel VBA ActiveX Series #3 Option buttons - Use on a sheet, How to group, Select with VBA
https://www.youtube.com/watch?v=R-Anu...


4. Excel VBA ActiveX Series #4 Combobox - Drop down you can resize and move. Fill with Custom criteria
https://www.youtube.com/watch?v=_NqyT...


5. Excel VBA ActiveX Series #4a Combobox - Macro when you change value on Dropdown menu
https://www.youtube.com/watch?v=GEy3f...


6. Excel VBA ActiveX Series #4b Combobox - Important Details about Combobox Properties
https://www.youtube.com/watch?v=l8-Ga...


7. Excel VBA ActiveX Series #4c Combobox - Alternate ways to fill combobox, 2+ columns in Cmb
https://www.youtube.com/watch?v=Xt6px...


8. Excel VBA ActiveX Series #5 SpinButton - Incrementing and decrementing a cells number, Move controls
https://www.youtube.com/watch?v=AVGqG...


9. Excel VBA ActiveX Series #6 ListBox - Easy Way to Fill a Listbox, Review Listbox Properties
https://www.youtube.com/watch?v=iKwaR...


10. Excel VBA ActiveX Series #7 ListBox - Custom Fill A Listbox Any Way You Want
https://www.youtube.com/watch?v=ulIra...


11. Excel VBA ActiveX Series #8 How to Fill Combobox with Table Q & A
https://www.youtube.com/watch?v=JwA2g...


12. Excel VBA ActiveX 12 SMILEY FACE Button on Worksheet
https://www.youtube.com/watch?v=mJ2Y2...


13. Excel VBA ActiveX 11 Select Multiple ws Objects Quickly
https://www.youtube.com/watch?v=Wv9dG...


14. Excel VBA ActiveX 10 Make a Shiny Modern Button on Worksheet
https://www.youtube.com/watch?v=HzsEm...


15. Excel VBA ActiveX 9 Make a Non-Glitchy Button on Worksheet
https://www.youtube.com/watch?v=FQEaz...


16. Excel VBA ActiveX 13 Spin Button to Go Up or Down the Combobox List
https://www.youtube.com/watch?v=cMOPl...


17. SUM of two or more Textboxes and Tricks to Automate This - Excel VBA
https://www.youtube.com/watch?v=UnnZg...


18. Use Command Button to Navigate Your Workbook Like a Hyperlink
https://www.youtube.com/watch?v=wjnIz...


19. Hide and Unhide Textbox, Manipulate data, Save File In Predetermined Location - EXCEL VBA!
https://www.youtube.com/watch?v=jQ9vz...


20. Embed Shockwave Flash in Excel - Livio's Example
https://www.youtube.com/watch?v=BxaVK...


21. How to Create 3 Column Listbox on Worksheet or Userform in Excel VBA
https://www.youtube.com/watch?v=pCuTg...


22. Copy Multiple Checkboxes or Activex Controls in Excel VBA
https://www.youtube.com/watch?v=BVV1_...


23. Disable Typing Over ComboBox Items - List Only in ComboBox in Excel VBA Dropdown
https://www.youtube.com/watch?v=o0rBn...


24. Two Comboboxes VBA Userform - One Controls the Other - Excel VBA Is Fun
https://www.youtube.com/watch?v=qvakb...


Excel/Wordオフィス製品のTipsまとめへ