Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having difficulty getting a user defined data type to function
with arrays. What I would like to do is create a data type that is comprised of four 1-D arrays. Then I would like to load the individual arrays in another module so I can trasnfer all four arrays as a single argument (the new data type) in a function. Here's what I have done so far In one module; Option Base 1 Public Type PlotScalars Xscalar(1 To 4) As Integer Yscalar(1 To 4) As Integer Zscalar(1 To 4) As Integer End Type In another module Dim MyPlotScalars As PlotScalars MyPlotScalars.Xscalar = Array(1, 0, 1, 1) MyPlotScalars.Yscalar = Array(1, 1, 0, 1) MyPlotScalars.Zscalar = Array(1, 1, 1, 0) I get an error "Compile error: can't assign to array." I would prefer not to have to load each element of the data type arrays one element at a time. Is there an easy way around this? My main motivation for doing this is to cut down on the number of arguments passed to a user defined function (which are limited to 30). TIA dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
Need help in excel with "Statement invalid outside Type block. " error | Excel Programming |