title: VBA - Update Other Cells via User-Defined Function
body: <p>I have a UDF(User-Defined Function) in VBA that needs to modify cell range on Excel. </p>
  
  <p>Since a UDF cannot do this, I tried using Event calls. </p>
  
  <p>When I raise a Custom Event and try to write to cells, I get #Value error. On the other hand, Application events such as 
  <code>Private Sub App_SheetChange(ByVal Sh As Object, ByVal Target As Range)</code> can write to cells. </p>
  
  <p>My questions is how do I update other cells by calling a UDF?</p>