I am very inexperienced in VBA, but I understand the basics. I was lucky to find some bits and pieces of code that have been posted, that have helped me somewhat accomplish my finished product! I have a userform with a combobox, textbox and 2 command buttons.
When the search results are populated, the data that contains hyperlinks are not active. The goal is to be able to click the selected result, which will open the link in a new excel workbook or worksheet. If it makes things easier, the only 2 columns that contain hyperlinks are column B and C.
In my attachment, it is a sample of data. So the only Allan has a hyperlink created.