Automatically Link via Shape Sheet

[RhesusMinus]

Hi.

I've got an Excel sheet full of part numbers and descriptions.
I've successfully connected my "drawing" to this excel sheet. However... When selecting an option in my shape, the part number of the shape changes (as it should), but the description must be updated from the excel sheet.
Is there any way in the shape sheet to trigger an Automatic Link/Refresh data when something changes?

THL

[RhesusMinus]

"Bump".. anyone know if this i possible?

THL

[aledlund]

In the shapesheet probably not, since autolink and refresh are two distinct operations. You'll probably have to do it with code.
al

[RhesusMinus]

Thanks for replying Al.

So.. how do I trigger my code from the shape sheet? I'll use the QUEUEMARKEREVENT function of course, but how do I make it trigger only when a cell changes value?

THL

[aledlund]

If I was doing it I'd probably use an Event Filter focused on the shape data fields changing. There is a good demo in the Visio SDK appropriately named  "event filter demo". The assumption on my part is that you are using a shapedata field to save your partnumber pointer.
Al