View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_21_] Michael[_21_] is offline
external usenet poster
 
Posts: 5
Default Is it possible to set a class member to be another class member?

I have what I hope is an easy question: Is it possible to set a class
member to be another class member?

Let me explain, I have two defined classes in excel,

clsSomeFucntion contains 4 members, 3 which are parameters (A, B, C)
and 1 which is an output function (Total):

clsSolver contains 6 members, 5 which are parameters (Target,
MinPrecision, detlax, IntialGuess and ChangeVariable), and 1 which is
an output function (SolverOut).

From a module, I have set all of the parameters in both class modules.
I need to set clsSover.ChangeVariable to be one of the three
clsSomeFunction members (parameters A,B,C) based on which one the user
wants to use as a solver variable.

That is to say, I want clsSover.ChangeVariable not to contain the
value of clsSomeFucntion.a, clsSomeFucntion.b, or clsSomeFucntion.c,
but to actually set it to be either clsSomeFucntion.a,
clsSomeFucntion.b, or clsSomeFucntion.c, so I can change it to iterate
a solution in clsSolver.solverOut. (clsSomeFucntion.total is the
output I am solving for).

I'm having trouble finding variable definitions in both the calling
module and the class module that let me do this.

Any suggestions?