VC 很简单:
const TCHAR cz_arrNames[10][50] = {
"小岗","小红","效力","张明","王武","","","","","" }VB呢?
dim names(10) as string
然后呢?
const TCHAR cz_arrNames[10][50] = {
"小岗","小红","效力","张明","王武","","","","","" }VB呢?
dim names(10) as string
然后呢?
解决方案 »
- adodc設置有錯嗎?
- 编写VB你们用什么开发工具
- 用ado连接一个200m的excel文件,速度奇慢!!
- 请教各位高手,关于把DataGrid表中的内容导入到OLE控件调出的EXECEL表的问题
- VB 中ActiveX 文档嵌入到IE中的问题? 高分求救 100分
- 表达式Chr(Int(Rnd*7+65))生成的范围是什么?
- 用winsock实现邮件收发的问题(用pop3,smtp协议)
- 对象变量或With块变量未设置
- 请问如何截获vb中操作SqlServer错误代码
- 谁能帮我写这样2个函数:1、从一文本文件中从开始位置读取指定长度的字符串。要求返回值能过滤回车符、换行符和...
- 本人现在需要一套人力资源源代码
- 下面的代码是什么意思,要怎样运行?
names(1)="小红"names(2)="张明"
......
Dim names
names = Array("小岗", "小红", "效力", "张明", "王武", "", "", "", "", "", "")
MsgBox names(2)
End Sub
names(0, 0) = "小岗"
names(0, 1) = "小红"
names(0, 2) = "效力"
names(0, 3) = "张明"
names(0, 4) = "王武"
MsgBox names(0, 1)
A = Array(10,20,30)
B = A(2)使用 Array 函数创建的数组的下界总是 0。这和其它类型的数组不同,它不受 Option Base 语句指定的下界的影响。注意 没有作为数组声明的 Variant 也可以表示数组。除了长度固定的字符串以及用户定义类型之外,Variant 变量可以表示任何类型的数组。尽管一个包含数组的 Variant 和一个元素为 Variant 类型的数组在概念上有所不同,但对数组元素的访问方式是相同的。
MyWeek = Array("Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun")
'返回值假设下界的设置为 1(使用 Option Base
' 语句)。
MyDay = MyWeek(2) 'MyDay 的值为 "Tue"。
MyDay = MyWeek(4) 'MyDay 的值为 "Thu"。
好像没全说清楚:我在Excel VBA中。
我采用了 Array 的方式:
Option Explicit
dim names
Sub Init(0
With ThisWorkbook.Worksheets("Sheet1")
names = Array( _
"xiaohong", _
"xiaoli", _
"xiaozhang" _
)
End With
End Sub
好像不行
Dim names()
names = Array( _
"xiaohong", _
"xiaoli", _
"xiaozhang" _
)
MsgBox (names(1))
End Sub
Dim names
Sub Init()
With ThisWorkbook.Worksheets("Sheet1")
names = Array( _
"xiaohong", _
"xiaoli", _
"xiaozhang" _
)
End With
MsgBox (names(0))
End Sub你的可以 在宏下调试通过了
另外,这种办法是动态分配数组个数的,如何获得数组的有效个数呢?
Dim names
names = Array("小岗", "小红", "效力", "张明", "王武", "", "", "", "", "", "")
MsgBox UBound(names)
End Sub
Private Sub Form_click()
Dim names
'赋值
names = Array("小明", "小红", "效力", "张明", "王武", "", "", "", "", "", "")
'通过Ubound()函数计算上界
i = UBound(names)
For j = 1 To i
Print names(j)
Next
End Sub
Private Sub Form_click()
Dim names
'赋值
names = Array("小明", "小红", "效力", "张明", "王武", "", "", "", "", "", "")
'通过Ubound()函数计算上界
i = UBound(names)
For j = 1 To i
Print names(j)
Next
End Sub
还可以用循环一个一个赋值