Re: $$Excel-Macros$$ use ComboBox value to select range and then use range to create a chart

Hi Ashish, Thank you so much for the awesome help. I really appreciate it! The workbook works fantastic!!! I have a few questions 1, Is it possible to use the values in D1: F1 (H3351, H3335, S3521) as the series names when creating the chart? How to do so in the macro? 2 When I click the dark b

$$Excel-Macros$$ use ComboBox value to select range and then use range to create a chart

Hi, I am trying to use VBA to achieve the following purpose: 1. a UserForm pops up once I open a workbook, and the value on the drop-down list of 2 ComboBoxes on the UserForm will be automatically populated. (I have designed the UserForm, open VBE to view it in the attached file)