excel - If the combobox text is equal to text in a column list, then follow hyperlink in cell to the right -

is consistent with the drop-down list in a blanket that I have a list of file details on a sheet. That's when the user selects any item in this drop down list, matches the text in the code column, and for the subsequent description, the link in the cell, thus I want to do a code like this Are there.

This is the code I have so far:

  select Private Sub Open_Button_Click () Case OI_FileName Case = OI_FileName.Value = Sheets ( "File_Paths") range ( "Details") with the value .. Open_Button each cell ( "Border Description") (Selection.OI_FileName = Cell.Value) re exit ActiveCell.Offset (0 for, 1) .Select Selection.Hyperlinks (1) .Follow new window: = False , AddHistory: = Compile Error ::. Without ending with  
 Any end of help you choose End Sub  

I'm sure this is because VBA displays is working properly this is not true with'm back end would be greatly appreciated offer

I was Nk it What are you looking for The statement was unnecessary.

  private sub Open_Button_Click () Dim StrFilePaths string dim as the CurrFileName string CurrFileName = OI_FileName.Value cell border each cell ( "Statement") StrFilePaths = Cell.Value so CurrFileName in = For StrFilePaths Offset (0, 1) .Select Selection.Hyperlinks (1) .Follow new window: = False, AddHistory: = True End If Next cell End Sub