View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
makulski makulski is offline
external usenet poster
 
Posts: 26
Default UDF reclac on move

I've written a function that returns the value of a cell on which a shape sits.
It's a calendar kind of thing:

Public Function ObjectDate(MyObject As String) As Date
Application.Volatile
ObjectDate = ActiveSheet.Shapes(MyObject).TopLeftCell
End Function

If the shape is moved from one cell to another, I'd like the function to
return the new date.

I found in this newsgroup the very helpful Application.Volatile.
The function now updates when the sheet recalcs. Yeah!

However, moving the shape doesn't cause the sheet to recalc.
Any suggestions?