Data validation dropdown with Hyperlink

[snake93]

Hi guys.

I found this video explaining how to create a dropdown menu with data validation. It is exactly what I was looking for, however, I was wondering if it was possible to add links in the dropdown menu.

Can someone help me ?

 

[Yongle]

Do you want clicking on dropdown item to behave like clicking on a hyperlink?

 

[snake93]

Vuoi fare clic su un elemento a discesa per comportarti come fare clic su un collegamento ipertestuale?

Exactly, in this way i have all reference at hand.

 

[Yongle]

data validation in cell A2 in Sheet1

list and links in Sheet2

Place this code in Sheet1 window (NOT in module like Module 1)

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address(0, 0) = "A2" Then
        On Error Resume Next
        Sheets("Sheet2").Range("A:A").Find(Target).Offset(, 1).Hyperlinks(1).Follow
        On Error GoTo 0
    End If
End Sub

Or do you want it to behave differently?

 

[snake93]

Thanks for your time, I really appreciate it.
It is exactly what I was looking for, but I have questions.

1. What is the VBA code for?

2. The dropdown menu in sheet1 also works without code. The function I was looking for is Option 1, Option 2 etc ... they must be hyperlinked based on sheet2's list.

3. I have a sheet downloaded from the internet with this feature, but I can't understand how it works.

I'm attaching it as an example: just that in the example file, I don't need 3 columns, just two, and when I delete a column nothing works.

Dropdown Hyperlinked List

 

[Yongle]

Sorry - I never download files
XL2BB is a site tool available to upload samle data to the thread

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[snake93]

Sorry, I didn't think MrExcel's policy was to not download files. Anyway, I was able to get the desired function thanks to combobox and some VBA code. This was possible thanks to a user of another forum; here is the solution.

Although I solved the problem I am interested in replicating the function with data validation, here is the sheet generated with xl2bb as suggested.

Dropdoen Hyperlinked List.xlsm
	A	B
1		Exercise
2		Squat
3		Bench
4		Deadlift
Scheda (Sheet1)

Cells with Data Validation
Cell	Allow	Criteria
B2:B4	List	=INDIRECT(exercise)
A1:A4	List	=city2

-

Dropdoen Hyperlinked List.xlsm
	A	B
1	Exercise	Link
2	Squat	https://www.youtube.com/watch?v=J_ekvFybels, https://www.youtube.com/watch?v=J_ekvFybels
3	Bench	https://www.youtube.com/watch?v=w0XBfuCC2WM&t=503s, https://www.youtube.com/watch?v=w0XBfuCC2WM&t=503s
4	Deadlift	https://www.youtube.com/watch?v=LGIS9vs65Sk&t=92s, https://www.youtube.com/watch?v=LGIS9vs65Sk&t=92s
DBS (Sheet2)

 

[Yongle]

Glad you have a solution. Thanks for posting link to it so that others may benefit.
Good luck

 

[Yongle]

Sorry, I didn't think MrExcel's policy was to not download files

It is nothing to do with MrExcel
It is my policy