UserForm + CheckBox + Hide/Unhide Columns

[rsbuzatto]

Hey folks,

I'm writing a VBA code to control the months of a process that I have here. However, I'd like to know if is there any good way to do it.

My UserFormis simple:

Jan May Sep No Selection
Feb Jun Oct Select All
Mar Jul Nov Data View
Apr Aug Dec




What I'd like to do is simple, as well: I need to press my Data View (Visualizar Dados) button and HIDE or UNHIDE (toggle) my month's data table.

Example: I'll select January and press Data View button and then, whether the January columns is hidden or not, do what I need. If January columns is hidden, my code must unhidden then and so on... If I check 2...3...7 months, my code must hide or unhide the columns.


TIP: Every month table has 6 columns, so I need to hide those 6 or unhide all of those six.

Can you guys help me?


Thanks a million!

 

[Mohammad Basem]

Try something like the following example,

[FONT="Consolas"][SIZE="2"][COLOR="Navy"]Private Sub CheckBox1_Click()
    Columns("A:G").Hidden = Not CheckBox1.Value
End Sub[/COLOR][/SIZE][/FONT]