Combobox with hyperlink

Hello guys

I'm pretty unnexperienced when it comes to excel macros/vba.

I think the problem i'm facing is simple to resolve for some of you, but not for me.

I have a list with 4 links. I want those links to appear one by one in the combobox. When i click the spin button it moves to the next. Its this simple. My problem is that i would like to see the text in the combobox as a hyperlink.

Is this possible?

Thank you for advance,
Kev

Originally Posted by kevsoulo

i would like to see the text in the combobox as a hyperlink.

What specifically do you mean? Do you mean that you want it to open the link if the user clicks on it, or are you just talking about formatting? You cannot put a hot link in a combobox but you can use the FollowHyperlink method to go to the link when the user selects it from the combobox.

Please Login or Register  to view this content.

If you are a little more specific about the exact behavior you want I can help further.

By the way linking the spin button is a peculiar way of using a combobox and defeats the purpose of allowing the user to pick from a list. This is not the normal way a combobox is used. What is the overall user experience you are trying to create?