Search results for query: *

So there's no way to keep from dedicating a sheet to store data? My ideal solution would be to have a way to go directly from an array in VBA to an Excel Chart without dumping the array in Excel first. Ben

Doesn't this keep the chart from updating also?

Does anyone know how to create an Excel chart directly from VBA without first putting the source data on a spreadsheet? I am trying to do a short animation by refreshing the chart a number of times. The problem is that the extra step of displaying the data on the spreadsheet slows down the...

I have a logitech mouse but had to download the Microsoft intellipoint drivers to get the wheel button to work in the editor. I haven't noticed any decreased functionality in other applications as a result of these drivers. Go to the website in Paul's post to get them. Ben

...Sheet_Profile.ChartObjects("Chart_Profile").Activate ActiveChart.PlotArea.Select Selection.Height = aspect_ratio * Selection.Width End Sub Here's the recorded macro that I need to modify to resize the chart area: Sub Macro3()...

That worked! I have a logitech mouse but the intellipoint drivers worked and allow me to scroll in the VBE. Thanks Wayne, have a star. Ben

You're right Skip. As I was re-reading my message I realized I was almost there. All I need to do is write some code to find the maximum value in the x and y directions and then I have my aspect ratio which I can apply to the chart. Thanks for your help Skip. Ben

That would work for shapes that are about as wide as they are tall. What I need is something that would work for shapes that are much taller than they are wide. For example, I have a shape that is 8 units tall and only 1 unit wide. I don't want to plot that on a chart that is 8x8 or 9x9...

I want to be able to create a chart that will automatically have the right aspect ratio. Say for example I was trying to plot an ellipse. Excel may plot that ellipse to look like an ellipse, or it could be stretched to look more like a circle, depending on the scale of the x and y 'Major...

Try checking the box for SOLVER in the VBA editor under Tools>References. I'm not sure if the Fourier Series is part of the solver package or not but it's worth a try. Ben

That was really cool! I've been wondering about a lot of the stuff demonstrated in that example. Star for you! Ben

I have the same problem as Bob. I've downloaded all the latest drivers for my logitech mouse but still no scroll in the code and immediate windows. There must be a menu somewhere that needs a checkbox checked or something. Ben

Maybe it's just my computer. I've tried removing everything from the Userform_initialize procedure but it still crashes. Well I guess we'll never find a solution to this one, it must be impossible. I really appreciate the help though. I'm just going to have to go with a button on a...

Nope. I added just where you told me to but it still crashes. These files were created and run in Excel 2002 on the same computer so there isn't any compatibility problems. I really appreciate you sticking with me on this Mike! At least you've helped somebody. If you have an epiphany...

Hey Mike, There are no links to external workbooks. The form does this. Private Sub UserForm_Initialize() 'from j-walk.com Call UpdateChart 'clears contents of specified cells Call Module_Clear_Contents.Clear_Contents End Sub I've tried removing UpdateChart, putting...

Hey Mike, I just tried that and I've opened the modified file about six times now and it crashes every other time. Any other suggestions? I appreciate the help and realize that there may not be a solution to this problem. (I'm hoping somebody takes that as a challenge to 'solve the...

Update: I'm using Excel 2002 if that helps. Ben

This is driving me nuts. It happens maybe 1 out of 3 times I open the file. I have found two cases which cause excel to crash and want to send an error report to microsoft. The first one is when I open a file in which I have a splash screen set up according to the directions given on this...

Ditto to xlbo! Thanks! Ben

Hi Tony, I guess I'll just code it in there. Thanks for the help! Ben