VBA code

D

DAGB

I need some Excel VBA code to be able to do the following:-

The user will select a month from a drop down list or combi-box.

If January is selected Columns C to M will be Hidden (plus other things)
If February is selected Columns D to M will be Hidden

Etc

Any help will be very gratefully received.

Many thanks in advance
 
J

Joel

Private Sub ComboBox1_Change()

If UCase(ComboBox1.Value) = "FEBRUARY" Then
Columns("C:M").EntireColumn.Hidden = True
Else
Columns("D:M").EntireColumn.Hidden = True
Columns("C").EntireColumn.Hidden = False
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Drop down list control value in vba 2
Automatically sending multiple parts of text from one word doc to another - is possible. 0
How to use/create code in MS Word to calculate age? 0
Link a text box based on drop down box with four options MS Word 365 0
VBA to run all variable combinations in a calculation model and store result 6
WORD VBA Search and switch to advanced ... 1
Dynamic Naming of Form Button 3

Top