Databases
StackOverflow2013
Postsdbo
POReturn a User Defined Data Type in an Excel Cell
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReturn a User Defined Data Type in an Excel Cell
    primarykey
    data
    text
    <p>I've searched the web and I've searched the questions here on stackoverflow, but I haven't been able to find a solution.</p> <p>Here is what I'd like to do:</p> <p>Suppose I have the following code in a class module named "MyClass"</p> <p><pre><code> Option Explicit Dim var1 as integer</p> <p>Sub Initialize(v as integer) var1 = v End Sub</p> <p>Function GetVar1() GetVar1 = var1 End Function </pre></code></p> <p>Then I have a UDF in a separate module with the code <pre> <code> Function InitializeMyClass(v as integer) as MyClass Dim myvar as MyClass Set myvar = new MyClass Call myvar.Initialize(v) Set InitializeMyClass = myvar End Function</p> <p>Function GetMyVar(m as MyClass) GetMyVar = m.GetVar1() End Function </pre></code></p> <p>Now in cell A1 I have "=InitializeMyClass(3)" and in Cell A2 I have "=GetMyVar(A1)". I get #VALUE errors in both cells. This of course is caused by the fact that I am trying to return a user defined data type into cell A1. I feel that this should be possible, but I am not sure how. </p> <p>Edit: Oh yeah, the question is, "Is there a way for me to return a user-defined data type into a cell and then have it be callable from another UDF in the example I gave above? I don't know if this requires COM or not. If it does, anyone know how I can get started? Ideally, if someone had an example of how this worked, that would be fantastic!"</p> <p>Another Edit: Here we go, now i know it can be done: read this description, it's not quantitative, but will give you a sense of what they do, <a href="http://www.quanttools.com/index.php?option=com_content&amp;task=view&amp;id=19" rel="nofollow noreferrer">http://www.quanttools.com/index.php?option=com_content&amp;task=view&amp;id=19</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLance Roberts
    1. USB Rivera
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReturn a User Defined Data Type in an Excel Cell
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POReturn a User Defined Data Type in an Excel Cell
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POReturn a User Defined Data Type in an Excel Cell
      1. This table or related slice is empty.
      1. VTUpMod
    1. COadditionally, I can't nest the functions either. Meaning, I am unable to do, "=GetMyVar(InitializeMyClass(3))" anyone have any ideas?
      singulars
      1. POReturn a User Defined Data Type in an Excel Cell
      1. USB Rivera
    2. COI don't think that the Formula or Value properties of Range objects can store references to objects. If you try Set myRange.Value = anObject it will fail. The same for Formula. If you omit the Set then it seems to pick up the default property of the object rather than the object itself
      singulars
      1. POReturn a User Defined Data Type in an Excel Cell
      1. USbarrowc
    3. COGetMyVar(InitializeMyClass(3)) works just fine in VBA. it seems like it should be able to work in an Excel cell. i can understand that there would be issues with returning a MyClass object in the cell (which is the main question), but at the very least, if the final return type is one that Excel recognizes, then "=GetMyVar(InitializeMyClass(3))" should work, since the cell doesn't actually have to store MyClass. the return value of InitializeMyClass is just passed into GetMyVar. also, i have seen this done before (scout's honor). but i don't know if i have to fiddle with COM or the like
      singulars
      1. POReturn a User Defined Data Type in an Excel Cell
      1. USB Rivera
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload