View Single Post
  #2 (permalink)  
Old June 11th, 2003, 06:00 AM
psychadelic psychadelic is offline
Authorized User
 
Join Date: Jun 2003
Location: Goodlands, n/a, Mauritius.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to psychadelic
Default

Hello

you can use dynamic arrays instead. Try this as an example:

Code:
     
Private Sub Command1_Click()

    Dim iCol As Integer
    Dim iRow As Integer

    iCol = 3    'or anything you want
    iRow = 3    'or anything you want
    ReDim arrData(1 To iCol, 1 To iRow)
'   instead of Dim arrData(1 to 3, 1 to 3)

'   set your array and put your code here
    MSChart1.ChartData = arrData
    DoEvents
    MsgBox "Voila..."

End Sub
regards,

psychadelic
Reply With Quote