Excel Code for populating hidden tab when option is selected in list box

[DesFitz]

Hello All,

First time post here. I have created a document which has a list box on the summary page in which items can be chosen. There are three tabs I have created for these options.

Examples of list drop down information: Fred, George, Liz, Fred & George, Fred & Liz, George & Liz, Fred & George & Liz.

Again, I have one hidden tab for each option. But I would like for the tabs appear once these options are selected. I did open the view code on the summary page and tried the following formula for the first option:



Private Sub CheckBox21_Click()
If CheckBox21.value = True Then Range("B234").value = True
If CheckBox21.value = False Then Range("B234").value = 0
Sheets("George").Visible = CheckBox21.value

Application.ScreenUpdating = True

End Sub

This did not work, although I have seen this formula used on another work document and it does work. Any help would be greatly appreciated.

Thanks,

DesFitz

 

[DesFitz]

Bump

 

[Norie]

How did that code not work?

 

[DesFitz]

It doesn't populate the tab when I select an option in the check-down box.

 

[Norie]

There's nothing in the posted code that would populate a cell, the only reference to a sheet is here,

Sheets("George").Visible = CheckBox21.value

and that is setting the visibility of the sheet 'George' based on the checkbox value.