高手帮忙看下如下代码,怎么能在拖动VScroll1时,mschart的显示能反映更快??
偶的VScroll1现在是分成了6段,但是从第三段开始反映的时间越来越慢,是不是数据从MSHFlexGrid1.TextMatrix(i, j)导出来的原因?''chart显示Private Sub MnuFdnt_Click()
VScroll1.Max = 546: VScroll1.Min = 0
VScroll1.LargeChange = 91: VScroll1.SmallChange = 91
Dim i, j, Max, Min As Integer
MSChart1.Visible = True
MSChart1.ChartType = VtChChartType2dLine
Min = 1
Max = Val(VScroll1.Value)
ReDim arrDatac3(Max, 8)
For i = 1 To Max
For j = 6 To 7
arrDatac3(i, j) = MSHFlexGrid1.TextMatrix(i, j)
MSChart1.ChartData = arrDatac3
MSChart1.ColumnLabel = i
Next j
Next i
End Sub
偶的VScroll1现在是分成了6段,但是从第三段开始反映的时间越来越慢,是不是数据从MSHFlexGrid1.TextMatrix(i, j)导出来的原因?''chart显示Private Sub MnuFdnt_Click()
VScroll1.Max = 546: VScroll1.Min = 0
VScroll1.LargeChange = 91: VScroll1.SmallChange = 91
Dim i, j, Max, Min As Integer
MSChart1.Visible = True
MSChart1.ChartType = VtChChartType2dLine
Min = 1
Max = Val(VScroll1.Value)
ReDim arrDatac3(Max, 8)
For i = 1 To Max
For j = 6 To 7
arrDatac3(i, j) = MSHFlexGrid1.TextMatrix(i, j)
MSChart1.ChartData = arrDatac3
MSChart1.ColumnLabel = i
Next j
Next i
End Sub
解决方案 »
- 实时错误 '3021' eof或eof 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录
- 【求助】VSFlexgrid控件能否实现和excel的自动筛选一样的功能
- [调查贴]请问各位现在还有多少人在用VB做开发的?
- 新手求教:VB串口问题
- 请教 注册表的读写问题
- 我想从一个数据库的三个相关联的表中读取固定的某几个字段追加到已存在的表中
- 关于internet transfer控件
- 绘图坐标转换
- 如何读取二进制文件?
- 新手的问题:非常漂亮的按钮是如何作成的?
- 我知道CSDN藏龙卧虎,各位兄台,能根据进程名得到程序完整路径吗?(高分)
- 怎么样能把我其他程序用编码的方式加载到我的另一个程序的缓存里?
VScroll1.Max = 546: VScroll1.Min = 0
VScroll1.LargeChange = 91: VScroll1.SmallChange = 91
Dim i, j, Max, Min As Integer
'----------------------------------
dim mhfGrid as MSHFlexGrid
Set mhfGrid = MSHFlexGrid1 '用一个对象变量指向MSHFlexGrid1,加快访问速度!
'----------------------------------
With MSChart1 '使用With提速
.Visible = False '提速
.ChartType = VtChChartType2dLine
Min = 1
Max = Val(VScroll1.Value)
ReDim arrDatac3(Max, 8)
For i = 1 To Max
For j = 6 To 7
arrDatac3(i, j) = mhfGrid.TextMatrix(i, j)
.ChartData = arrDatac3
.ColumnLabel = i
Next j
Next i
.Visible = True '显示
End With
End Sub
我换上你的程序,简单测速,未见效果,还是比较慢,再帮偶想想办法?解决好的话,偶会继续加分的!
VScroll1.Max = 546: VScroll1.Min = 0
VScroll1.LargeChange = 91: VScroll1.SmallChange = 91
Dim i, j, Max, Min As Integer
'----------------------------------
dim mhfGrid as MSHFlexGrid
Set mhfGrid = MSHFlexGrid1 '用一个对象变量指向MSHFlexGrid1,加快访问速度!
'----------------------------------
With MSChart1 '使用With提速
.Visible = False '提速
.ChartType = VtChChartType2dLine
Min = 1
Max = Val(VScroll1.Value)
ReDim arrDatac3(Max, 8)
For i = 1 To Max
For j = 6 To 7
arrDatac3(i, j) = mhfGrid.TextMatrix(i, j) .ColumnLabel = i
Next j
Next i
.ChartData = arrDatac3 '没看仔细哈,此句放在循环外试试!?
.Visible = True '显示
End With
End Sub