LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell range not changing when refreshing linked data- sumproduct fo lharp21 Excel Worksheet Functions 1 February 25th 10 10:56 PM
Function Values Not Refreshing Carlee Excel Worksheet Functions 3 September 11th 08 02:03 PM
How can I stop charts from refreshing when changing source data? Jens Rauff Charts and Charting in Excel 0 June 22nd 06 08:30 AM
Refreshing a User Defined Function ChrisA Excel Discussion (Misc queries) 1 November 11th 05 06:56 PM
refreshing custom function Juggernnath Excel Programming 1 October 6th 03 01:17 PM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"