Did some searching around and this should be straightforward, but I am struggling with it (still coming up the learning curve).
I would like to create a function where I call a variable like:
x = Range("NamedRange").Value
Where "NamedRange" is the name of a cell
Then I want to pass "x" to the function, but I would also like to pass "x" to many functions as well.
From what I can see, I need something like:
Public x as Double
but I am not sure in which part of the module to define "x" in (is does not like to be in the Declarations section it seems.
As an additional note, how do I get the function to update when "x" has been updated. I saw a bit of code by Chip Pearson, but was confused by it. The point is that VBA does not know that "x" has been updated unless you specify it with proper code or use the "volatile" switch (but that bogs the code down too much).
Thanks, hope this was not too confusing.