Anyone got an example of how to use a combo box to select hyperlinks to take you off to the selected website? I have this, which works but it's hard-coded - I'm looking for something a little more dynamic, i.e. pick up hyperlinks from a range on a sheet.

   Dim strAddress As String
    Select Case intIndex
    Case 0
        strAddress = "http://www.reverso.net/text_translation.asp?lang=en"
    Case 1
        strAddress = "http://translate.google.com/translate_t?"
    Case 2
        strAddress = "http://www.wordreference.com/"
        
    End Select
    
     ThisWorkbook.FollowHyperlink strAddress, , True