Question

vb中的textbox如何有格式地输入excel 急!!

testbox有一行有格式的文字"A,B,C,D,E"(ABCD为中文文字)文字与文字之间有","隔开,想把文字输入到excel的特定单元格,象如下所示
objSheet.Cells(1, 1) = A
objSheet.Cells(1, 2) = B
objSheet.Cells(1, 3) = C
objSheet.Cells(1, 4) = D
objSheet.Cells(2, 1) = E
谢谢!!!

Answer 1

很简单..

Dim wb() As String
wb = Split("A,B,C,D,E", ",")
objSheet.Cells(1, 1) = wb(0)
objSheet.Cells(1, 2) = wb(1)
objSheet.Cells(1, 3) = wb(2)
objSheet.Cells(1, 4) = wb(3)
objSheet.Cells(2, 1) = wb(4)

Answer 2

说得容易做得难。