List Box That Can Run Macros Based on Selection

[Fishing4answers]

Hello,
I am trying to get a Listbox to run a macro. I have the box open with 6 items. Based on the selection a macro will run for the specific choice.

Example:
If January is selected Sheets("January"). Visible=true
Create a drop down 1-4
If August is selected Sheets("August"). Visible=true

And so on.
Any help would be appreciated.

 

[Crystalyzer]

Where is the listbox on a userform or on a worksheet? If a worksheet can you post a copy of it using XL2BB?

 

[Fishing4answers]

Proof of concept.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1			Type
2	Months		1	2	3					Months
3	January		x	x	x
4	February		x
5	March			x	x
6	April
7	May
8	June
9	July
10	August
11	September
12	October
13	November
14	December
15
16
17
18
Landing Page

The boxlist isn't showing in the preview but it is in the excel.

To add more context to the example. We received options for January, February, and March. I want those tabs to now be displayed since I selected them. There will be additional prompts in prior tabs to fill out the data on those sheets. The idea is that we can only see what is applicable without manually hiding and showing (the actual worksheet has 30+ options). Once I select March I want to be able to then only show the 2nd option and 3rd.
Let me know if this helps.

 

[Fishing4answers]

Where is the listbox on a userform or on a worksheet? If a worksheet can you post a copy of it using XL2BB?

The boxlist isn't showing in the preview but it is in the excel.

To add more context to the example. We received options for January, February, and March. I want those tabs to now be displayed since I selected them. There will be additional prompts in prior tabs to fill out the data on those sheets. The idea is that we can only see what is applicable without manually hiding and showing (the actual worksheet has 30+ options). Once I select March I want to be able to then only show the 2nd option and 3rd.
Let me know if this helps.