VBA compiler compiling errors

P

PhuongM

New member

• Aug 31, 2017

• #1

I got a compiling error with the following code:

Dim XS2RunList() as long

How can I get the VBA Compiler work with dynamic array?

I also got compiling error with other misc. constants ie vbYesNo, vbCrLf, xlNone, xlContinuous, xlInterrupt,xlErrorHandler

How can I get around them?

 

gdgsupport

Support

Staff member

• Sep 2, 2017

• #2

Dynamic arrays use a different convention. Here is a basic sample:

Code:

Sub MyProtectedSub(Param1)

' Create a dynamic array
DIM PTIM = VarArrayCreate([0,3000,0,5], 12)

' Assign a value:
PTIM[1,2] = 1530

'Show the value:
MsgBox (PTIM[1,2])
End Sub

For the unknown constants, we’re checking why they are not recognized.

 

Last edited: Sep 4, 2017

P

PhuongM

New member

• Sep 2, 2017

• #3

Thanks for replying.

What’s does the number 12 in the vararraycreate function mean?

 

gdgsupport

Support

Staff member

• Sep 2, 2017

• #4

It’s an internal parameter. Always use 12.

 

P

PhuongM

New member

• Sep 3, 2017

• #5

It works. Thank you.