refreshing VB function after changing value
 

I have created a VB function which look like this:
public function function_1 (parameter1 as string, parameter2 as integer) as
string

my form look like this:
A B
1 5 =function_1("03.2004";row())
2 10 =function_1("03.2004";row())

I noticed that when I change the values from cells: A1 and A2, the function
(function_1)
isn`t updated automatically, that`s why this value returned by this
function, is now older/previous
one. How to refresh the value returned by this function automatically after
changing cells A1, A2??

Any help appreciated
Thankx
Best regards
Marcin

refreshing VB function after changing value
 

Hi
see your reply in Excel.misc

P.S.: please don't multipost


--
Regards
Frank Kabel
Frankfurt, Germany


Marcin Zmyslowski wrote:
I have created a VB function which look like this:
public function function_1 (parameter1 as string, parameter2 as
integer) as string

my form look like this:
A B
1 5 =function_1("03.2004";row())
2 10 =function_1("03.2004";row())

I noticed that when I change the values from cells: A1 and A2, the
function (function_1)
isn`t updated automatically, that`s why this value returned by this
function, is now older/previous
one. How to refresh the value returned by this function automatically
after changing cells A1, A2??

Any help appreciated
Thankx
Best regards
Marcin

refreshing VB function after changing value
 

functions only update if their parameters change: neither of the two
parameters in your function refer to A1 or A2, so the function will not
update.

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Marcin Zmyslowski" wrote in message
...
I have created a VB function which look like this:
public function function_1 (parameter1 as string, parameter2 as integer)
as
string

my form look like this:
A B
1 5 =function_1("03.2004";row())
2 10 =function_1("03.2004";row())

I noticed that when I change the values from cells: A1 and A2, the
function
(function_1)
isn`t updated automatically, that`s why this value returned by this
function, is now older/previous
one. How to refresh the value returned by this function automatically
after
changing cells A1, A2??

Any help appreciated
Thankx
Best regards
Marcin