title: Associating a vb Object to a specific worksheet
body: <p>I'm working with VB in Excel (Office 2010).</p>
  
  <p>I have a class called Problem and a vb code that generates random problems and for each problem creates a new worksheet and prints the parameters of the problem to that worksheet.</p>
  
  <p>when I work on that worksheet, I need some of the parameters that are stored in the instance of the Problem object that generated the worksheet and change them dynamically. </p>
  
  <p>what I would like to do is associate an instance of the Problem to its worksheet
  something like:</p>
  
  <pre><code> Dim p as Problem 
  
   Set p = new Problem 
  
   Worksheet("Problem 1").**myCurrentProblem** = p 
  </code></pre>
  
  <p>and then later on have access to the variable <code>myCurrentProblem</code></p>
  
  <p>is there a way to do that?</p>
  
  <p>thanks in advance.</p>