[算表] excel vba textbox multiline輸入(出)
office 2016
excel
請教各位大神
已知textbox可以multiline登打資料上去
==========
比方說資料呈現如下 in textbox1
==========
aaa
bbbb
cc
ddd
==========
我該如何把aaa丟到range.[a1]
bbbb丟到range.[a2]
cc丟到range.[a3]
ddd丟到range.[a4]
另外,如果想反向把range的資料
丟到textbox2,該如何處理?
google找不太到資料,也許是我看不懂
故懇請各位大神提供簡單範例研究
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.236.102.10
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1493450872.A.6D1.html
→
04/29 15:46, , 1F
04/29 15:46, 1F
→
04/29 15:47, , 2F
04/29 15:47, 2F
→
04/29 15:50, , 3F
04/29 15:50, 3F
→
04/29 15:52, , 4F
04/29 15:52, 4F
→
04/29 15:55, , 5F
04/29 15:55, 5F
→
04/29 15:56, , 6F
04/29 15:56, 6F
→
04/29 15:56, , 7F
04/29 15:56, 7F
→
04/29 15:56, , 8F
04/29 15:56, 8F
→
04/29 15:57, , 9F
04/29 15:57, 9F
→
04/29 16:00, , 10F
04/29 16:00, 10F
→
04/29 16:01, , 11F
04/29 16:01, 11F
→
04/29 16:01, , 12F
04/29 16:01, 12F
→
04/29 16:02, , 13F
04/29 16:02, 13F
→
04/29 16:03, , 14F
04/29 16:03, 14F
→
04/29 17:51, , 15F
04/29 17:51, 15F
→
04/29 17:52, , 16F
04/29 17:52, 16F
→
04/29 17:53, , 17F
04/29 17:53, 17F
→
04/29 17:54, , 18F
04/29 17:54, 18F
→
04/29 17:55, , 19F
04/29 17:55, 19F
→
04/29 18:01, , 20F
04/29 18:01, 20F
→
04/29 18:01, , 21F
04/29 18:01, 21F
→
04/29 18:05, , 22F
04/29 18:05, 22F
→
04/29 18:06, , 23F
04/29 18:06, 23F
※ 編輯: CamryHybridQ (122.117.124.204), 04/29/2017 18:06:41
→
04/29 18:19, , 24F
04/29 18:19, 24F
→
04/29 21:13, , 25F
04/29 21:13, 25F
→
04/29 22:45, , 26F
04/29 22:45, 26F