title: How to stop VBA function showing formula result in Arguments Dialog in MS Excel
body: <p>When we add a UDF to MS-Excel using VBA, the function gets evaluated twice when inserting:</p>
  
  <p>1) As soon as all the arguments are given to the function in FUNCTION ARGUMENTS dialog: Hence the result is shown in FUNCTION ARGUMENTS dialog itself as Formula Result</p>
  
  <p>2) After clicking OK in FUNCTION ARGUMENTS dialog: Hence the result is shown in the respective cell.</p>
  
  <p>I also referred to <a href="https://stackoverflow.com/questions/2611929/stop-vba-evaluate-from-calling-target-function-twice">Stop VBA Evaluate from calling target function twice</a> but it made the function does not get evaluated ever.</p>
  
  <p>Can I please know a way of stopping this double evaluation of a UDF function?</p>
  
  <p>Thanks</p>