Auto-refreshing VBA modules/functions/macroes

[Sebastian Stormbo]

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]

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?