VBA activates shapesheet on event

[rhatcher]

Can someone provide and example of VBA code to monitor for an event,
and when that event occurs, activate a formula in a cell.

Thanks

 

[Al Edlund]

I'd start over here

http://msdn.microsoft.com/library/en-us/devref/HTML/DVS_21_Event_Handling_857.asp?frame=true#847

al

 

[rhatcher]

Thanks Al, Whats embarasing is I own a copy of the DVS. Ive gotten
myself wrapped around this thing so bad Ive lost all sense of direction
.

Thaks again

 

[Al Edlund]

don't feel bad, I seem to do it on a daily basis lately.
al

 

[rhatcher]

Ok, that's seems to gel pretty good. Next question:

I need to fire an event that isn't on the event list. However, I know
its there because I see it occurring using the event monitor.

From the event monitor: 13025 >EnterScope Refresh Shapes

[67640;0;Refresh Shapes]

It occurs when the document opens and when manually fired from the
page. But I don't find it in the Document, Page or Application event
lists. Is it a "special" event and more importantly can code be
written behind it?

Is there documentation on this?

 

[Al Edlund]

Just off the top of my head with no research the first hint might be "enter
scope" which would indicate it is some type of marker event. The second part
of the clue, is that since marker events have tags, is that some piece of
code is setting the scope and executing the refresh. So firing a "event"
isn't what you are looking for (assumption is that you want to do a
refresh). Things to consider when trying to protect from partial draws are
"Application.ScreenUpdating " and ensuring that you have enough "doevents"
inside of your loops so that the system is allowed to catch up before moving
on to something else.
al

Ok, that's seems to gel pretty good. Next question:

I need to fire an event that isn't on the event list. However, I know
its there because I see it occurring using the event monitor.

From the event monitor: 13025 >EnterScope Refresh Shapes

[67640;0;Refresh Shapes]

It occurs when the document opens and when manually fired from the
page. But I don't find it in the Document, Page or Application event
lists. Is it a "special" event and more importantly can code be
written behind it?

Is there documentation on this?

 

[rhatcher]

Actualy I just want to record the date and time that it happens, so I
can let the user know the last time that shape was updated from the
database.

 

[rhatcher]

Or, I should say "refreshed" from the database.

 

[Al Edlund]

then you might consider using an addadvise to capture the marker event and
watch for the 'refresh' flag.
al

 

[rhatcher]

Thanks Al, addadvise, marker event and 'refresh' flag It is!