+ Reply to Thread
Results 1 to 4 of 4

Get value from Dynamic Variables

  1. #1
    Registered User
    Join Date
    10-01-2009
    Location
    Manassas, VA
    MS-Off Ver
    Excel 2007
    Posts
    86

    Get value from Dynamic Variables

    Please Login or Register  to view this content.
    My intention is to display the value of Text1 and Text2, not the actual word "Text1" nor "Text2". If removing "" then I would get the 1 and 2 and still not the value of the variables.

    Would you help with this please?

    Thanks,

    Nathan

  2. #2
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: Get value from Dynamic Variables

    You could use an array to do what you are asking which is essentially construct variable names - the easiest way would be with an array.
    Please Login or Register  to view this content.
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

  3. #3
    Registered User
    Join Date
    10-01-2009
    Location
    Manassas, VA
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Get value from Dynamic Variables

    Anthony,

    That helped with the sample I provided, So I THANK YOU for that. However, my goal is really to find how to turn text into variable name and eventually get the value assigned.

    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: Get value from Dynamic Variables

    If you are intent on going down that path then
    Please Login or Register  to view this content.
    This will allow you to construct variable names. That being said I still think arrays are a better way to go.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1