Change hyperlink (Command Button) based on Drop Down List result

Question

Hello...

I have a a drop down list which contains 12 names. Is it possible to have a one command button that will link file base on list choosed?

Answer 1

How to make Command Button go to hyperlink based on value choosed in G6?

You want to call the link directly?

Let us assume G6 contains then

http://www.microsoft.com

you can use that:

Sub Test()

  ThisWorkbook.FollowHyperlink Range("G6")

End Sub

A file link should also work.

Andreas.

Answer 2

Hi Andreas Killer

Sorry late reply, away from PC for moment...

Ok then..but how to intergrate to Command Button. Lets says :

C2 : HYPERLINK("http://www.microsoft.com")

C3 : HYPERLINK("..\data.xlsx","sheet1!A1")

C4 : HYPERLINK("C:\My Documents\Drawing1.vsdx")

C5 : HYPERLINK("\Server\Share\Drawing1.vsdx")

G6 : Drop Down List box 

How to make Command Button go to hyperlink based on value choosed in G6?

Appreciates the helps. TQ.

Answer 3

Yes, use a HYPERLINK formula.

https://msdn.microsoft.com/en-us/library/office/ff767465.aspx?f=255&MSPPError=-2147217396

Andreas.