Hello A cell contain a private function D18 = Get_NamedString() The function work well when I select the cell then press enter. As this cell function is linked to a global variable, how could I code it to be updated automatically. Even the recalculate button from the tool bar doen not modify the value Public Function Call_GetNamedString() As String Dim String_i As String String_i = GV_GetNamedString("DataString", "error ") Call_GetNamedString = String_i End Function ' How could I force the cell to call the function at least every 500 millisecond or even 1 second Martin

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to force a function to be calculated

Thread starter mtheriault2000
Start date Jul 19, 2011

mtheriault2000

Well-known Member

Jul 19, 2011

Hello

A cell contain a private function

Code:

D18 = Get_NamedString()

The function work well when I select the cell then press enter.

As this cell function is linked to a global variable, how could I code it to be updated automatically. Even the recalculate button from the tool bar doen not modify the value

Code:

Public Function Call_GetNamedString() As String
   Dim String_i As String
   String_i = GV_GetNamedString("DataString", "error ")
   Call_GetNamedString = String_i
End Function
'

How could I force the cell to call the function at least every 500 millisecond or even 1 second

Martin