作者查詢 / unfinish
作者 unfinish 在 PTT [ Visual_Basic ] 看板的留言(推文), 共43則
限定看板:Visual_Basic
看板排序:
全部Gossiping4827joke67ask-why47car43Visual_Basic43gallantry42sex33home-sale28CarShop26Little-Games24Salary21CHING20specialman16ChungLi14ChineseMed12haiku11radio10TuTsau9ADS8HatePolitics8Wargaming8Anti-ramp6Database6Office6CSMU-CM-OP5Employee5NIHONGO5swim5YOLO5kualab4MartialArts4medstudent4movie4PublicServan4Ancient3bicycle3book3CGI-Game3H-GAME3IA3Instant_Food3Language3PublicIssue3Shu-Lin3ShuangHe3SongShan3Android2AppleDaily2BCC_PCC2e-coupon2Ecophilia2gay2hypermall2JapanStudy2KS94-3202MOD2NTUFS-982NTUND982PingTung2PttLifeLaw2SouthPark2Teacher2TKU_EE_92C2TryingTimes2Violation2Warfare2About_Life1ask1Baki1Beauty1BigShiLin1BikerShop1BLEACH1Boy-Girl1Browsers1Bus1C_and_CPP1CGSH87th_3151CGSH88th3181Chemistry1Chi-Gong1ck52nd3211ck54th3331CTSH913051CVS1Digitalhome1Disabled1DragonBall1e-shopping1EAseries1eSports1Facebook1FJU-ACC90a1FJU-ACC93a1FJU_Chiayun1Free_box1FuMouDiscuss1FXM91-3291GAMEMUSIC1Geography1Google1GossipPicket1GUNDAM1Hate1Health1HSNU_10081HSNU_10091IC-Card1IME1Japan_Living1japanavgirls1JLPT1KanColle1kawaii1kodomo1KUAS1Kusan_89-3121L_TalkandCha1Lan-Yu1LAW1lifeguard081LTK1marvel1media-chaos1Miaoli1Militarylife1MonkeyPox1MP98-1T1mud1NBA1NCCU_Magic1NCCU_SEED1NCHU-SWC1NCU94Stat1NCU95Stat1NetRumor1Network1NIUECE911NIUEE93a1NLHS-Chat1nobunyaga1NTUCH-901NTUot941ONE_PIECE1onePiece1Oni_soul1P2PSoftWare1P_Management1paranormal1Question1Railway1SET1Stock1streetfight1studyteacher1SYSOP1TA_AN1Tech_Job1TFG02Unity1TFG03Winner1TMU_GIMI931Tobacco1ToS1TPC_Police1Trans-nctu1travian1TW-language1TypeMoon1VET_921Violin1WorkanTravel1YP90-3101YP93-3041<< 收起看板(173)
3F推:VBA不能用{}來填值 2個方法 1.逐一填值 2.array函數04/17 14:16
4F→:方法1: a(0)=1.1 a(1)=2.1 a(3)=3.104/17 14:17
5F→:方法2:Dim a As Variant a=Array(1.1,2.1,3.1)04/17 14:20
6F→:注意方法2中a的型態只能為Variant04/17 14:23
8F→:我不是前輩 我也是新手 XD04/20 13:35
1F推:ActiveCell.Address 回傳目前作用中儲存格的位置03/30 18:01
16F推:要抓系統時間用time或now函數 now僅有時間 time包含日期03/22 09:18
17F→:ex. when=time() 想清空變數請用null ex. when=null03/22 09:20
18F→:to MOONRAKER: null跟empty是不一樣的.....03/22 09:21
19F推:也不是說MOONRAKER說的不對 如果一開始有宣告a的資料型態03/22 09:33
20F→:那對a來說""就是清空了 這個時候是沒有辦法令 a=null03/22 09:35
21F推:若是未經宣告直接使用變數 那a會依內容自動改變資料型態03/22 09:43
22F→:使用a=null除內容也會一併把資料型態設為null03/22 09:45
25F→:你最行最會 原po要是懂還要上來問嗎 有必要用那種口氣嗎03/22 19:56
1F→:忘了說,存檔時要存成.csv檔 再把.csv改成.txt就行了05/01 02:23