can you do this in VBA (similar to C structures) 1

[shetlandbob]

Hi,

Can you do this or similar in VBA (Excel 2000):

[green]// this is how I would do it in C[/green]
struct myCoords
{
  double x;
  double y;
};
struct myBox
{
  myCoords coords;
  double   xLength;
  double   yLength;
};

[green]//  more code
// so that you can have[/green]

  myBox box;
  
  box.coords.x = 0;
  box.coords.y = 0;
  box.xLength = 1;
  box.yLength = 1;

}

I'm using a class module and have some small containers that I will be using a number of times, and wondered if I can do it in a similar way as above?

Thanks,





Robert Cumming

http://www.consultantengineer.co.uk

 

[earthandfire]

Public Type MyCoords
  x As Double
  y As Double
End Type

Public Type MyBox
  Coords As MyCoords
  xLength As Double
  yLength As Double
End Type

Public Sub ABox()
Dim TheBox As MyBox

  TheBox.Coords.x = 12
  TheBox.Coords.y = 12
  TheBox.xLength = 25
  TheBox.yLength = 30

End Sub

Hope this helps.

 

[shetlandbob]

Ah "Type" yes now I remember!!!

I knew there was a way, but for the life of me I couldn't think!!

Thanks



Robert Cumming

http://www.consultantengineer.co.uk