click hyperlink from listview

Hi Everyone!

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.

Any help would be greatly appreciated!

cnimes

Thank you so much for your reply!

I have attached a sample of my database. Once the results are populated, I would like to be able to click the result and it will open in a new sheet. The hyperlink is in column B or C. I have one example with a hyperlink (Client ALLAN).

Let me know if that makes more sense!

Thank you again!

Help PLEASE!!

Any suggestions? I'm open to changing what is currently is!

I'm afraid I can't help much here.
You're using a version of excel I've never used and a control I've never used. (I use Listboxes rather than list views.)
I tried to do some quick research on Listviews but I'm still not sure how to implement what you want.

I got this far....but when I hit "Finish", I get a window that says "Cannot Open the Specified File" with a runtime error message.

Any thoughts?

Please Login or Register  to view this content.

The last line comes back with the error message.