Basic-Excel-R-Toolkit icon indicating copy to clipboard operation
Basic-Excel-R-Toolkit copied to clipboard

Delay in graph shape being ready

Open amoynahan opened this issue 6 years ago • 0 comments

I am having a problem moving a shape created by BERT in my VBA code. If I run the VBA macro that calls Bert to create the chart, and then submit in a second call for the code to move the shape, it works. If I try to combine the code it does not work. I think it's possible the shape does not yet exist when I combine calls. I can also make it work if I call the move code from a worksheet event such as "SelectionChange." However, this make the application look awkward.

Introduction.txt

Heromod Vignettes.xlsx

amoynahan avatar Apr 19 '18 14:04 amoynahan