Search found 5 matches
- Wed May 08, 2024 11:49 am
- Forum: ActiveX
- Topic: Cannot set chart height
- Replies: 8
- Views: 4366
Re: Cannot set chart height
I'm glad you were able to catch the problem. Looking forward to hearing what you find. Thanks for looking into this.
- Mon Apr 29, 2024 5:10 pm
- Forum: ActiveX
- Topic: Cannot set chart height
- Replies: 8
- Views: 4366
Re: Cannot set chart height
I'm sorry, I wasn't clear.
The Start button is on the "Home" sheet of Excel, not the Home tab.
Troy
The Start button is on the "Home" sheet of Excel, not the Home tab.
Troy
- Sun Apr 28, 2024 11:04 am
- Forum: ActiveX
- Topic: Cannot set chart height
- Replies: 8
- Views: 4366
Re: Cannot set chart height
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...
- Fri Apr 12, 2024 8:34 pm
- Forum: ActiveX
- Topic: Cannot set chart height
- Replies: 8
- Views: 4366
Re: Cannot set chart height
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...
- Sat Feb 10, 2024 1:34 am
- Forum: ActiveX
- Topic: Cannot set chart height
- Replies: 8
- Views: 4366
Cannot set chart height
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...