refreshing VB function after changing value

[Marcin Zmyslowski]

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

 

[Frank Kabel]

Hi
see your reply in Excel.misc

P.S.: please don't multipost

 

[Charles Williams]

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