Hello everyone,

I am having a problem which I cannot seem to figure out. Even though it
seems -- and probably is -- a easy solution to.

Here it is. I have a several columns of 300+ rows which use a function (or
is it called a macro, or module?) that I created myself in VBA. They call
this function with values from other cells as parametres, but when I alter
the values of these other cells, the cells which call on the VBA functions
dont update -- their value doesnt change. Only when I click on the cell and
press enter.

This is drastically inconvinient for me, because the data from the cells
which call upon the VBA function make out a chart that was supposed to be
flexible. The entire point of this chart is to be able to alter the cells
that contain the parametres [for the cells which use the VBA function], and
adjust it untill you find the kind of result your looking for.

So, does anyone know

"Sebastian Stormbo" wrote:

> Hello everyone,
>
> I am having a problem which I cannot seem to figure out. Even though it
> seems -- and probably is -- a easy solution to.
>
> Here it is. I have a several columns of 300+ rows which use a function (or
> is it called a macro, or module?) that I created myself in VBA. They call
> this function with values from other cells as parametres, but when I alter
> the values of these other cells, the cells which call on the VBA functions
> dont update -- their value doesnt change. Only when I click on the cell and
> press enter.
>
> This is drastically inconvinient for me, because the data from the cells
> which call upon the VBA function make out a chart that was supposed to be
> flexible. The entire point of this chart is to be able to alter the cells
> that contain the parametres [for the cells which use the VBA function], and
> adjust it untill you find the kind of result your looking for.
>
> So, does anyone know

..... how to make the cells update themselves automatically every time I
change their parametres?