VBA create Listbox and populate with Hyperlinks

Closed
Chrisebell
Posts
1
Registration date
Saturday July 6, 2013
Status
Member
Last seen
July 6, 2013
- Jul 6, 2013 at 03:39 PM
Hello all,

I am working on a project to create a data pull from the internet to obtain a news feed for a given stock. I currently ran into a problem though in displaying my output. Because of the amount of links, I would like to put web addresses with display names into a newly created listbox using only VBA.

I have gotten to the point of building my array with the web address & the name for each link, so I need to now:

1. Create a brand new listbox without selecting it
2. Create hyperlink objects
3. put the hyperlink objects into the list box

Any help would be greatly appreciated!