Vba

[Darth Vodka]

In VBA, if I'm declaring 3 variables in a class object definition, e.g.

Public strY1GraphType As String
Public strY2GraphType As String
Public strY3GraphType As String

which works fine

How come it won't let me declare

Public strGraphType(3) As String

????

As arrays are not allowed in object modules :-(

 

[Steven]

In VBA, if I'm declaring 3 variables in a class object definition, e.g.

Public strY1GraphType As String
Public strY2GraphType As String
Public strY3GraphType As String

which works fine

How come it won't let me declare

Public strGraphType(3) As String

????

As arrays are not allowed in object modules :-(

Is the syntax correct ?

 

[Darth Vodka]

Is the syntax correct ?

hmmm

i need to declare it as private and then do let & get....

ho hum

 

[Steven]

hmmm

i need to declare it as private and then do let & get....

ho hum

If this follows the Java style then I would expect something like

Public strGraphType() As String

then a declaration to allocate the size of the array

Somevbafunctiontosizearrays strGraphType(3);

 

[pds]

Somevbafunctiontosizearrays strGraphType(3);

I agree.

 

[Steven]

Did this get sorted?

 

[Darth Vodka]

Did this get sorted?

yeah, i ended up with:-

Private int_P_GraphType(3) As Integer

Public Property Get intGraphType(Index As Integer) As Integer
intGraphType = int_P_GraphType(Index)
End Property
Public Property Let intGraphType(Index As Integer, ByVal NewValue As Integer)
int_P_GraphType(Index) = NewValue
End Property


i'm working on an access databases that kicks out graphs in a spready, it's pretty good