Display Charts in a UserForm based on Combo Box Selection

**HangMan** · 07-12-2011, 06:54 AM

I am trying to work out how to display a chart in a UserForm, based on the user selection from a Combo Box. I have looked at the John Walkenbach solution, but have been unable to successfully adapt this to meet my needs.

I have attached a simple sample file to demonstrate what I am trying to achieve. I have a UserForm with an Image Control, a Combo Box, a Text Box and a Close Button.

I have three charts and what I want to be able to achieve is for the user to select an option from the dropdown menu and for the appropriate chart to be displayed in the Image Control and for the Text from the Combo Box to be displayed in the Text Box above the chart.

I have got as far as being able to display the 'first' chart in the Image Control, but it displays the same chart irrespective of which option I select from the Combo Box and I have no idea how to display the relevant text in the Text Box. I would like to have the first chart already displayed in the Image Control when the user launches the UserForm.

I am no expert when it comes to VBA, so if anyone is able to help, with simple step by step instructions indicating which code goes where that would be gratefully appreciated, so I can try to understand the logic.

**Andy Pope** · 07-12-2011, 07:31 AM

You are not changing the chart number argument in the combo change event

Please Login or Register  to view this content.

**HangMan** · 07-12-2011, 07:38 AM

Hi Andy

OK, that makes sense and works. Many thanks...

How would I go about displaying the first chart in the list by default when the UserForm is launched, rather than the Image Cntrol being blank and how can I then display the text from the Combo Box in the Text Field?

**Andy Pope** · 07-12-2011, 07:40 AM

Set the value of the combobox to the 1st item.

Please Login or Register  to view this content.

**HangMan** · 07-12-2011, 07:43 AM

Easy when you know how... As you can tell I'm learning!

Any thoughts on the final part, how to then display the text from the ComboBox in the Text Field above the chart?

**Andy Pope** · 07-12-2011, 07:45 AM

Please Login or Register  to view this content.

**HangMan** · 07-12-2011, 07:57 AM

Andy

Thank you so much, I have spent the last two days trying to figure out how to do this and you have solved my problem in 5 minutes. I guess knowledge goes a long way...

I really appreciate your help - I think I need to find a good VBA book to read...

**HangMan** · 07-12-2011, 08:12 AM

Andy

Sorry to bother you again... Let me know if it is inappropriate to post and if I need to post this as a seperate topic

One additional thing, slightly off topic, but how can I rescale the graphs to fill the Image Control? If I rescale the 3 graphs and then view them in the UserForm, they automatically revert back to their original size?

**cinstanl** · 05-26-2016, 09:00 AM

Not sure If I need to start another posts, or If I can ask questions on this one. I have a similar situation, except it is not a user form it is a dashboard and there are no buttons and all of the charts are on another sheet within the workbook? Not sure how I can modify this code to give me what I need. I tried another code that I had found through google and it is not working for me either. I only have today to get this done, any help would be appreciated. I have looked and cannot find an area where I can upload the file. PLEASE HELP!