Import Data and create charts in Excel sheet using Excel VBA active X combo box drop down selection

[praveen123]

I am trying to use Excel VBA to import data into my active workbook and then use two combo boxes(which should get populated once the data is imported) drop down menu's to make a selection of any two variables from the data and create a choice of chart(Line, Scatter etc). I have already done the import data part but facing a problem in using combo boxes. Please somebody can guide me in the right direction with the code.

 

[Andrew Poulsom]

Welcome to MrExcel.

Maybe this will help you:

Select a Chart Type Using a List Box or Drop Down

 

[praveen123]

Welcome to MrExcel.

Maybe this will help you:

Select a Chart Type Using a List Box or Drop Down

Hi Andrew ,
Thanks for responding!

I am enclosing a sample table( though this is not fixed)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Var 1[/TD]
[TD]Var 2[/TD]
[TD]Var 3[/TD]
[TD]Var 4[/TD]
[TD]Var 5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I am trying to do is have two drop down menu's which can automatically populate itself with the column headers( here Var 1, Var 2, Var3 etc) and then using these choices to create charts of my choice( line, bar or scatter).

Tasks:
- Two drop downs needed.
- The dropdowns should be dynamic to populate itself with the column headers (var1, var2 var3 etc here) based on the data imported.
- Once the selection is done, chart can be created to analyse to the two selections( line, bar or scatter)

I am really new to VBA and hence facing huge problem in coding for this. Would appreciate your help if you can help out with the code.