作者查詢 / Catbert
作者 Catbert 在 PTT [ Visual_Basic ] 看板的留言(推文), 共48則
限定看板:Visual_Basic
看板排序:
全部Office267Visual_Basic48Soft_Job45Database33BigSanchung23Monkeys22MIS19tax16Accounting14Koei11Neihu9PC_Shopping8Salary8Windows6EZsoft5java5creditcard4Baseball3C_Sharp3Gossiping3marriage3NBA3P_Management3Trace3BeautyBody2FITNESS2HatePolitics2LCD2MuscleBeach2Programming2Python2R_Language2RealPlaying2StupidClown2WomenTalk2C_Chat1ck56th3151CodeJob1Detective1Eclipse1FJU-ACC94b1GetMarry1Jeremy_Lin1LTK1MobileComm1movie1NCCU_SEED1Nethood1Nets1NTU-EM921NTUACCTR951Sangokumusou1Sijhih1Statistics1WinNT1XBOX1<< 收起看板(56)
1F→: Protect的後面加上 Password:="password"06/06 21:57
1F推: Cells()後面要加上.Address,不然預設屬性是.Value05/14 20:29
2F→: https://www.ptt.cc/bbs/Office/M.1203246065.A.857.html01/17 18:16
8F→: http://www.vixual.net/blog/archives/7308/19 13:06
4F→: 呼叫Rnd前要加入Randomize MSDN:https://goo.gl/sGDe5406/29 08:49
5F→: 另外可用Application.Version來判斷Excel版本06/29 08:52
1F推: range("A3:B5").select10/23 21:11
1F→: ThisWorkbook.VBProject.vbcomponents.Remove _09/29 21:49
2F→: VBP.vbcomponents("Module2")09/29 21:49
3F→: 直接用Shell呼叫CMD執行DEL03/14 00:06
2F→: Range(Cells(8, 3).address, Cells(8, 28).address)02/17 12:54
5F→: Office板#16jpAV-X02/04 00:57