excel-vba
差異處
這裏顯示二個版本的差異處。
|
excel-vba [2009/03/12 13:40] bestlong |
excel-vba [2010/08/23 15:30] (目前版本) |
||
|---|---|---|---|
| 行 65: | 行 65: | ||
| End Sub | End Sub | ||
| </code> | </code> | ||
| - | |||
| == 選取所有儲存格 == | == 選取所有儲存格 == | ||
| <code> | <code> | ||
| 行 72: | 行 71: | ||
| End Sub | End Sub | ||
| </code> | </code> | ||
| - | == 選取單一儲存格範圍 == | + | === 取得 / 設定 儲存格的值 === |
| <code> | <code> | ||
| + | Sub GetValueRange1() | ||
| + | MsgBox Range("A1").Value | ||
| + | End Sub | ||
| + | </code> | ||
| + | <code> | ||
| + | Sub SetValueRange1() | ||
| + | Range("A1").Value = 123.456 '通用格式 | ||
| + | Range("A2").Value = "-1,234,500" '千分位 | ||
| + | Range("A3").Value = "2009/01/01" '日期 | ||
| + | Range("A4").Value = "11:22:33" '時間 | ||
| + | Range("A5").Value = "01234" '文字 | ||
| + | End Sub | ||
| + | </code> | ||
| + | === 取得 / 設定 儲存格的計算式 === | ||
| + | == 設定計算式 == | ||
| + | <code> | ||
| + | Sub FormulaRange1() | ||
| + | Range("A10").Formula = "=SUM(A1:A9)" | ||
| + | Range("B10").Formula = "=AVERAGE(B1:B9)" | ||
| + | Range("C10").Formula = "=MAX(C1:C9)" | ||
| + | Range("D10").Formula = "=MIN(D1:D9)" | ||
| + | End Sub | ||
| + | </code> | ||
| + | == 絕對參照 / 相對參照 == | ||
| + | <code> | ||
| + | Sub FormulaRange1() | ||
| + | Range("A3").Formula = "=$A$1+$A$2" '絕對參照 | ||
| + | Range("B3").Formula = "=B1+B2" '相對參照 | ||
| + | End Sub | ||
| </code> | </code> | ||
| 行 87: | 行 115: | ||
| ===== 網路資源 ===== | ===== 網路資源 ===== | ||
| + | ==== 討論區 ==== | ||
| + | * http://gb.twbts.com/index.php?board=3.0 麻辣家族討論區 Excel 討論版 | ||
| + | * http://www.officefans.net/ OfficeFans.net 菁英俱樂部(簡) | ||
| + | * http://www.excelpx.com/ Excel 菁英 討論區(簡) | ||
| + | * http://www.excelhome.net/ Excel HOME http://club.excelhome.net 討論區 http://blog.excelhome.net Blog | ||
| + | ==== BLOG ==== | ||
| + | * [[http://blog.xuite.net/fvba/vbatips|Excel VBA Tips 志工教學]] | ||
| + | * [[http://blog.xuite.net/crdotlin/excel|Excel VBA Comics]] | ||
| + | * [[http://www.wretch.cc/blog/HUNGCHILIN|HUNGCHILIN的Excel分享空間]] | ||
| + | * [[http://chijanzen.net/wp/|chijanzen 雜貨舖]] | ||
| + | * [[http://cat14051.mysinablog.com|Emily 分享學習 VBA]] | ||
| + | * [[http://hi.baidu.com/officecm|ExcelFans]] | ||
| + | ==== 其他 ==== | ||
| * [[http://spreadsheetpage.com|The Spreadsheet Page]] | * [[http://spreadsheetpage.com|The Spreadsheet Page]] | ||
| * http://puremis.net/excel | * http://puremis.net/excel | ||
| 行 99: | 行 140: | ||
| * http://www.andypope.info | * http://www.andypope.info | ||
| * http://www.dailydoseofexcel.com | * http://www.dailydoseofexcel.com | ||
| - | |||
| - | * [[http://blog.xuite.net/fvba/vbatips|Excel VBA Tips 志工教學]] | ||
| - | * [[http://blog.xuite.net/crdotlin/excel|Excel VBA Comics]] | ||
| - | * [[http://www.wretch.cc/blog/HUNGCHILIN|HUNGCHILIN的Excel分享空間]] | ||
| - | * [[http://chijanzen.net/wp/|chijanzen 雜貨舖]] | ||
| - | * [[http://cat14051.mysinablog.com|Emily 分享學習 VBA]] | ||
| - | * [[http://www.excelhome.net|ExcelHOME]] [[http://club.excelhome.net|討論區]] [[http://blog.excelhome.net|Blog]] | ||
| - | * [[http://hi.baidu.com/officecm|ExcelFans]] | ||
excel-vba.1236836439.txt.gz · 上一次變更: 2010/08/23 15:30 (外部編輯)
若未特別註明，此維基上的內容都是採用以下授權方式： CC Attribution-Noncommercial-Share Alike 3.0 Unported
