解決 Excel 任何疑難雜症的最終方案！快速上手 VBA 讓你變成 Excel 類大師！| Excel 教學 50 - Vidude

16 Views· 27 July 2022

解決 Excel 任何疑難雜症的最終方案！快速上手 VBA 讓你變成 Excel 類大師！| Excel 教學 50

0

0

Advertisement

Advertise With Vidude

Subscribers

Education

► 內容綱要
00:00 開場白
01:47 使用 VBA 產生對話框
02:46 使用語法指定選取範圍
04:00 使用錄製巨集來參考 VBA 語法
05:07 儲存包含巨集的活頁簿
05:51 使用 End & Offset 設定動態範圍
07:05 變數建立與宣告
10:02 迴圈 (Loop) 語法
12:33 If 條件判斷式
13:41 綜合練習
16:01 建立按鈕

► 教學資源
練習檔 (載點一) https://tinyurl.com/y4kb3gfp
練習檔 (載點二) https://share.weiyun.com/psVa8iLl

► Papaya 電腦教室會員專區 (加入後可觀看會員專區的影片喔)
加入頻道會員 https://tinyurl.com/sxt3d2b
會員專區影片目錄 https://tinyurl.com/y6mvo38a

#記得打開影片的CC字幕喔 #Excel #VBA #巨集

Show more

Shorts

A master Torcedor (cigar roller) in his element #cigars #thestogielife

A master Torcedor (cigar roller) in his element #cigars #thestogielife

A couple saved a mountain lion lying on the road #shorts

A couple saved a mountain lion lying on the road #shorts

This family nurtured a kestrel outside their window, and then this happened #animalshorts

This family nurtured a kestrel outside their window, and then this happened #animalshorts

Trapped Inside 💡🔦 shot with @NikonEurope #nikonz9 #tutorial #photoshoot

Trapped Inside 💡🔦 shot with @NikonEurope #nikonz9 #tutorial #photoshoot

Beautiful Street Fashion Outfits Style #shorts

Beautiful Street Fashion Outfits Style #shorts

@NinjaWarrior with style💃🏽💪🏻👀 #girlpower #nbc #shorts #youtubeshorts #ninjawarrior

@NinjaWarrior with style💃🏽💪🏻👀 #girlpower #nbc #shorts #youtubeshorts #ninjawarrior

Up next

Autoplay

Advertisement

Advertise With Vidude

0 Comments

Film & Animation Music & Arts Pets & Animals Sports & Outdoors Travel & Events Gaming People & Vlogs Comedy Entertainment News & Politics How-to & Style Design & Creativity Homes & Real Estate Autos & Vehicles Education Science & Technology Fashion & Beauty Cooking & Foodie TV & Drama Products & Reviews Health & Wellbeing Brand & Premieres Documentary Local Business & Services Other