Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    21

    Unanswered: Having a cell point out to which variable to use in equation.

    Heres the Scenario:

    In Excel:

    Cells(1,1) = "Variable1"
    Cells(1,2) = "+"
    Cells(1,3) = "Variable2"

    In VBA
    Dim Variable1 as integer, Variable2 as integer
    Variable1=1
    Varable2=1
    Test = Cells(1,1) & Cells(1,2) & Cells(1,3)

    Obviously this will not work
    But the Idea I want to convey is that is it possible to have this statement return a value of 2

    Let me know if you need me to explain further.
    Last edited by Amazing_Spiderman; 09-30-06 at 08:04.

  2. #2
    Join Date
    Aug 2006
    Posts
    21
    The only other thing i can think of is using a Len Statement and a Select Case Statement to pick out which variable or sign is chosen.

  3. #3
    Join Date
    Aug 2006
    Posts
    21
    Issue Resolved ... Len Statements and Select Cases work perfectly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •