Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel arrows don't move black box but move the window | Excel Discussion (Misc queries) | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
How do I stop making the spreadsht move when I move up/dwn/lt/rt? | Excel Worksheet Functions | |||
2 strange items in Excel (reclac and Add-in) | Excel Discussion (Misc queries) | |||
When I move scroll bar in excell the contents do not move with it | Excel Discussion (Misc queries) |