Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

05_建立兌獎副程式與陣列存放資料(EXCEL函數與VBA 吳老師分享)

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
39 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 12, 2011

EXCEL函數與VBA雲端班第5次上課

延續上次大樂透的課程將函數建立大樂透程式改成VBA的方式,
多了很多程式設計的解決方案,
但可以看出若有程式底子的同學和沒有程式基礎的就有截然不同的反應,
之後的課程會繼續以範例的方式,了解外部文字匯入匯出與資料庫應用。

吳老師 100/7/12

01_解說如何將函數改成VBA
02_在VBA建立搖獎機副程式
03_將結果寫到儲存格中
04_建立選號副程式
05_建立兌獎副程式與陣列存放資料
06_選號與搖獎機號碼比兌
07_產生開獎按鈕連結副程式
08_增加將結果記錄下來的功能
09_自訂副程式與傳送參數與中斷點建立
10_程式碼匯出分享與匯入
11_將核取方塊改成控制工具箱元件

吳老師教學網:
http://3cc.cc/10g
部落格:
http://terry55wu.blogspot.com/
論壇:
http://groups.google.com/group/excelvbacloud?hl=zh-TW
溫馨考場論壇:
http://123.205.192.177/uc/bbs/index.php/

EXCEL,VBA,函數,自強基金會,吳清輝老師,程式設計,線上教學,e化創新,雲端計算,虛擬電腦,吳老師提供

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more