【引数が苦手な人へ】VBAの引数を実例付きで100%完全攻略【永久保存版】

【⏳Timestamps】 00:35 It's the same mechanism as X + Y = Z that you learned in school! 02:05 Let's start by understanding the [simple code] 03:06 Sub with arguments. It gets progressively more difficult, but let's do our best! 03:50 Function section~ 04:33 Function with arguments. You'll use it a lot! 05:12 Summary 05:50 How do you use them differently in [actual work]? Answered with specific examples. 07:45 Do you know how to write code with arguments? 12:47 This is the most commonly used example in actual work (Function with arguments) 15:25 So what's so convenient and amazing about using arguments and Functions? 16:40 Please subscribe to the channel!!! At 10:27, it says "because it's a Sub, call it with Call," but you can call it without writing Call. It seems like an old way of writing it, but the current trend is to not write it. However, in large-scale projects involving multiple developers, these are sometimes intentionally left in for readability or personal preference reasons. '------------------------------------------------------------- We now live in an age where ChatGPT and Copilot can automatically write VBA code. However, are you struggling with issues like "the macro created by AI doesn't work" or "I don't know the cause of the error"? 90% of the time, the cause lies in not understanding the mechanism of "arguments," the heart of macros. Precisely because we live in the age of AI, understanding "arguments" now will allow you to utilize AI 10 times more effectively. A former DX engineer explains it in the most easy-to-understand way possible with diagrams! #vba #vbabeginner #macro #excelmacro #excel 【✏️Now on sale on Udemy! 】 ▼ "Access Basic Operations and Practical Skills Course + MOS Exam Preparation [2016 Compatible]" https://www.udemy.com/course/accessmo... ▼ Excel VBA Standard Certification Exam Preparation Course Now Available! https://www.udemy.com/course/excelvba... For 【💰¥490/month】 ・Exclusive videos only available to members Why not get them? ↓↓↓Join here↓↓↓    / @smartworkhacksjp   ------------------------------ 【🎁Special gift for members only】 *Please check the member-only videos and community for the password https://smartworkhacks.jp/members_only/ 💬 Thank you for your always warm comments! ------------------------------ [For business inquiries, please contact us here] *We do not accept personal inquiries or sales solicitations. [email protected] ------------------------------ [👛Merchandise Sales: BOOTH] You can purchase items at a 10% discount compared to the SUZURI site⭐️ (※Materials and types of items available may differ. Please understand.) https://urawainformation.booth.pm/ ------------------------------ [📹Main materials and sources used in the video] AC, Irasutoya, Atago-sama, DOVA-SYNDROME, and many others We take great care regarding copyright, but please contact us if you have any concerns. ------------------------------ ●X Real-time tweets [  / uis14_  ] ●TikTok [  / uis14_  ] ●Instagram Daily life, travel, and information sharing [  / uis14_  ] ⚪️Sub-channel "CODE's Break Time" [   / @code_breaktime  ] *Participating in the Amazon Associates Program ------------------------------ ▶Recommended Video ▷【Just One Video】Excel VBA Macro Beginner's Guide! What is Excel VBA Macro? From this, you can see:    • 【たった１動画】ExcelVBAマクロ初心者入門講座！エクセルVBAマクロとは？から分かる   ▷【Just 3 Hours】Access VBA Macro Beginner's Guide    • 【たった３時間】AccessVBAマクロ初心者入門講座   ▷【Must-See for Beginners】Learn Python Basics in Just 1 Hour! Super Beginner's Edition    • 【たった1動画】Python初心者入門講座！Pythonとは？から分かる   ＋＋＋＋＋＋＋＋ *We are aiming for 100,000 subscribers by 2026. We need your support! 😀 Please subscribe and like! 🥚 April 1, 2022: Channel Launched 🐣 February 1, 2023: 1,000 Subscribers 🐤 May 1, 2024: 10,000 Subscribers 🐓 January 16, 2025: 20,000 Subscribers 🐦‍🔥 September 20, 2025: 30,000 Subscribers ＋＋＋＋＋＋＋＋ 【🪪Career & Achievements】 ・As a DX Engineer, I have been involved in the modification and new development of over 300 tools for major companies and public works projects, from the upstream processes. ・I have mentored young people in VBA, Python, etc. --------------------------- #vba #excel #vbabeginner #ChatGPT #copilot #ai #arguments #Function