Displaying graphs on userforms
 

Hello

I wonder if anyone can help.

I compile performance stats for my company using an excel spreadsheet onto
which I have added buttons that open userforms that display graphs of the
stats that are held in separate hidden worksheets.

The problem is that I do this in a very inefficient way.

Everytime I update the graphs I:-

1. Unhide the worksheet with the graph
2. Copy the worksheet into paint
3. Cut out the graph and save as a paint file in a folder on my hard drive
4. Open the VBE and select the userform.
5. Change the picture file to the new version of the paint file
6. Close the VBE and hide the worksheet with the graph

Does anyone know of an easier way of doing this?

Any assistance would be much appreciated

Many thanks in advance and kind regards, Nick

Displaying graphs on userforms
 

John Walkenbach has an easier way:

http://www.j-walk.com/ss/excel/tips/tip66.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" wrote in message
...
Hello

I wonder if anyone can help.

I compile performance stats for my company using an excel spreadsheet onto
which I have added buttons that open userforms that display graphs of the
stats that are held in separate hidden worksheets.

The problem is that I do this in a very inefficient way.

Everytime I update the graphs I:-

1. Unhide the worksheet with the graph
2. Copy the worksheet into paint
3. Cut out the graph and save as a paint file in a folder on my hard drive
4. Open the VBE and select the userform.
5. Change the picture file to the new version of the paint file
6. Close the VBE and hide the worksheet with the graph

Does anyone know of an easier way of doing this?

Any assistance would be much appreciated

Many thanks in advance and kind regards, Nick

Displaying graphs on userforms
 

This is spot on Jon many thanks

Nick
"Jon Peltier" wrote:

John Walkenbach has an easier way:

http://www.j-walk.com/ss/excel/tips/tip66.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" wrote in message
...
Hello

I wonder if anyone can help.

I compile performance stats for my company using an excel spreadsheet onto
which I have added buttons that open userforms that display graphs of the
stats that are held in separate hidden worksheets.

The problem is that I do this in a very inefficient way.

Everytime I update the graphs I:-

1. Unhide the worksheet with the graph
2. Copy the worksheet into paint
3. Cut out the graph and save as a paint file in a folder on my hard drive
4. Open the VBE and select the userform.
5. Change the picture file to the new version of the paint file
6. Close the VBE and hide the worksheet with the graph

Does anyone know of an easier way of doing this?

Any assistance would be much appreciated

Many thanks in advance and kind regards, Nick