Displaying graphs on userforms

N

Nick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top