Application.Volatile.. When to use, When not to use

[mtheriault2000]

Hello

I have seen in a code, application.volatile = True and I'm not sure whether or not it apply to my need

Public Function Call_GetNamedString() As String
   Dim String_i As String
   Application.Volatile True
   String_i = GV_GetNamedString("DataString", "error")
   Call_GetNamedString = String_i
    Application.Volatile True
End Function

Anyone could give me another explanation than the one in the Help from Excel. I just don't catch it

Martin

 

[pgc01]

Hi Martin

The Application.Volatile makes the code of the udf to be executed everytime the worksheet recalculates and so you should always avoid it if you can.

The good practice is to define the function with the inputs that should trigger the recalculation.

In your case you have no parameters in your udf which is not usual. What are you trying to do? What are the inputs that should trigger the recalculation?

 

[mtheriault2000]

Hello PGC01

The function is use in the context of communication between Excel and an external software. Some info are exchange between them using a Global Variable concept. Excel and the other software (Multicharts), use the same named Global Variables to exchange information.

Since external data may come in in any moment, I want to be able to read and update my sheet accordingly to the new data.

With your little explanation, i understand a bit more now.

Martin