Results 1 to 7 of 7

how to create a "persistent" variable definition?

Threaded View

MCCCLXXXV how to create a "persistent"... 12-03-2013, 02:46 PM
Solus Rankin Re: how to create a... 12-03-2013, 02:58 PM
MCCCLXXXV Re: how to create a... 12-03-2013, 03:07 PM
Solus Rankin Re: how to create a... 12-03-2013, 03:29 PM
MCCCLXXXV Re: how to create a... 12-03-2013, 04:08 PM
MrShorty Re: how to create a... 12-03-2013, 05:46 PM
MCCCLXXXV Re: how to create a... 12-04-2013, 07:25 AM
  1. #1
    Forum Contributor
    Join Date
    09-28-2007
    Location
    New York, NY
    MS-Off Ver
    2007
    Posts
    120

    how to create a "persistent" variable definition?

    Is it possible to create a "dependent" variable that is recalculated automatically when its "independent" variables are changed. For example, can I somehow define y = 3*x +5 such that y is instantly updated when x changes somewhere later in the code? As of now, I would have to re-write the "y=3*x+5" line of code after every time x *might* change.

    I tried searching for this but I have no idea what to search for exactly.

    Thanks very much!
    Last edited by MCCCLXXXV; 12-04-2013 at 07:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Object Browser "View Definition" icon is grayed out
    By RonByrd in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 05-14-2013, 04:18 AM
  2. Using VBA to create a variable "adjustable cells" array in Solver
    By Kybynn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2012, 12:25 AM
  3. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 PM
  4. [SOLVED] use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM
  5. [SOLVED] VBA code to create "variable" worksheets within a workbook
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2005, 10:05 PM

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