Thread: VBA UDF Calculation (not)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Longtin Greg Longtin is offline
external usenet poster
  
Posts: 3
Default VBA UDF Calculation (not)
To all,

I've got a UDF, but Excel will only calc it when the cell containing it is
edited, ie, F2, enter.

How can I force a calc? I tried 'Calculate' on the SheetActivate event, and
nothing happens...

TIA,

Greg


Reply With QuoteReply With Quote