I created a table with a ID, and Textbox for the hyperlink. It's important that the hyperlink is text.
I then created a listbox on my form with the hyperlinks in the listbox.
In the onclick event for the listbox here's the code:
Application.FollowHyperlink Me.List8.Column(1), , True
Since I was pulling 2 columns (ID, Hyperlink) I had to point at the second column. If your listbox is 1 column only, eliminate the .column(1)
Hope this works!