I'm glad you were able to catch the problem. Looking forward to hearing what you find. Thanks for looking into this.

I'm sorry, I wasn't clear.

The Start button is on the "Home" sheet of Excel, not the Home tab.

Troy

I have gutted out my program to the minimum code to show the issue. The code may not compile due to the gutting process, but the remaining code is enough to execute and show the issue. To test: 1. Open the file 2. Open the VBA Development Environment 3. Open the modMain code block 4. Hit the Start b...

I tried setting the width and height outside the "With" block, using a fixed value (300). When stepping through the code, the frmMain.TChartCABondOrder.Height value is always 49151.25. It completely ignores the "300". So it's not the "With" block. I've tried setting a long variable to 300 then setti...

I cannot set the height of a chart. I'm trying to use a simple formula to calculate how much space I have available on a VBA multipage control on a form (in Excel) after I load a few other objects. Whatever space I have left on the from, I'd like to use for the chart. With frmMain.TChart1 .Top = frm...