Select column using a combo box??

[limeister]

Hello Excel gurus,

I am a bit weary of asking for help because it's only my 2nd post and I haven't helped out anyone here. Sorry guys. I am not a excel expert.

I have created a userform with a combobox. The combo box is already linked with dates. i.e. When I click on combo box I can select a date.

This was the easy part.

My question is it possible to select a column or a specified range based on what I select in my combobox?

For example, If I select the date 06-Jan-2010 from the combo box, I want to be able to make Column A active.

If I chose 13-Jan-2010 then Column B is active.

Basically want and try and do this for the entire 2010 year so I guess I need 52 separate lines of code?!?

Thanks in advance.

p.s. I made this userform from basically cut and pasting and modifying codes I found on the internet. Don't understand a thing about VB. Sorry.

 

[somnath_it2006]

You have to do like this:

Private Sub ComboBox1_Change()
    
    If ComboBox1.Value = "06-Jan-2010" Then
        Columns("A:A").Select
    End If
    
End Sub

 

[limeister]

Thanks for that! I was dreading it might require 52 lines of code!!
No worries. I guess there is no other way.

 

[mikerickson]

Assuming that 6.Jan'10 is the first entry in the combo box's list, etc.

Private Sub ComboBox1_Change()
    With ComboBox1
        If -1 < .ListIndex Then
            ThisWorkbook.Sheets("Sheet1").Columns(.ListIndex + 1).Select
        End If
    End With
End Sub

 

[limeister]

Cool I might try this too!