How can I change a cell value inside a VB function

[renatoab]

I have a function wich is called in a cell.
When the function find some problem, I want to register the error in another sheet at the same file, as a log. But when I'm into the function, I'm not able to set values to other cells, a runtime error occur.

Even if I make a separate Sub, the same occurs.
Running the sub separately, it works, but when it is called by the function, it doesn't work.

How can I do this? I want to store the informations about the functions' errors, but I don't want to use an external file, because it will become slow.

Thanks in advance

 

[PCL]

A way to do could be ( a bit long):
Have a variable as global where is stored the error code

Global ERROR_Check

In the code for the sheet (sheet1) where is the function, use

Private Sub Worksheet_Calculate()
    Call ESSAI
End Sub

In the subroutine ESSAI store the error code

Sub ESSAI()
    Sheets("Sheet2").Cells(2, 2) = ERROR_Check
End Sub