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

D

Dennis

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

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
 
D

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?
 
D

Dennis

al,

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