Do I have to wait for ShapeSheet to recalc? How?

[Dennis]

The following code only gives the correct result when a
breakpoint is set on the second statement:

 

[al]

I usually try to liberally sprinkle my visio code
with 'DoEvents' so that any background updates can be
applied. This is especially true since a single cell
update can cascade through a significant amount of other
cells in an object (each of which can fire events).
al

 

[Dennis]

thanks al,

I couldn't find any reference to 'doevent' in VBA. I did,
however, find references in VB. Unfortunately I not using
VB. Were you meaning 'doevent' literally?

 

[Dennis]

al,

I put a 'DoEvents' statement after the first line of the
sample code and everything worked great. Thanks for the
tip.