Hello, very new to VBA, mid-level at excel.
This is my first project and i need help. I have two sheets, one name TEMP and the other HUM.
They contain climate data, mean temperatures per month for every state and HUM contain Humidity values.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Mean T.[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So, i design a form with 2 Buttons ( to select the sheet TEMP or HUM), 3 comboboxes (One for select the table, one to select A or B and on more to select the month) and an image to display the produced chart.
I'm very new to VBA, so every help is accepted!!!!
This is my first project and i need help. I have two sheets, one name TEMP and the other HUM.
They contain climate data, mean temperatures per month for every state and HUM contain Humidity values.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Mean T.[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So, i design a form with 2 Buttons ( to select the sheet TEMP or HUM), 3 comboboxes (One for select the table, one to select A or B and on more to select the month) and an image to display the produced chart.
I'm very new to VBA, so every help is accepted!!!!