Launch URL in Cell by Clicking Command Button?

[Rekd]

I've got a userform in a spreadsheet and want to launch a link that is stored in a cell based on a search result.

For example, user types in a part number. If the part number is found it calculates based on quantity in one cell and grabs pricing data for that part. I'd also like to be able to click a command button and have it launch a link stored in a different cell on the same row as the part number.

How can I get the URL from the cell in column B row 155? I've tried things like

 Result = Range("B" & FoundRow).Hyperlinks

But it errors. When I type "Hyperlinks." it gives me an option to "add" and some other optionss, but not to simply get the value.

TYIA

 

[Rekd]

Found it.

 Result = Range("B" & FoundRow).Hyperlinks(1).Address

Go, me!