Search found 7 matches

by TGagnon
Sun Jun 30, 2024 10:21 pm
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

Re: Cannot set chart height

Thank you for the follow up.

When I look on the site, I don't see that version listed. Am I to presume that my upgrade option has expired and I have to repurchase the product?

Troy
by TGagnon
Tue Jun 25, 2024 1:35 am
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

Re: Cannot set chart height

Hi. Just checking in. Have you found any cause for this issue yet?

Thanks.

Troy
by TGagnon
Wed May 08, 2024 11:49 am
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

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.
by TGagnon
Mon Apr 29, 2024 5:10 pm
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

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
by TGagnon
Sun Apr 28, 2024 11:04 am
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

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...
by TGagnon
Fri Apr 12, 2024 8:34 pm
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

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...
by TGagnon
Sat Feb 10, 2024 1:34 am
Forum: ActiveX
Topic: Cannot set chart height
Replies: 13
Views: 56038

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...