Hello Maarten,
I think you have to include the workbook name and a specify a range in the worksheet. E.g. say your workbook is called MyBook this will work:-
=IF($F$34="Gebouw verbeekstraat",HYPERLINK("[MyBook.xls]Hoofdscherm!A1","GO"),"NO DATA")
HTH,
D
Oke I tried that too, but it gives #NAME?
IF($F$34="Gebouw verbeekstraat";HYPERLINK("[ruimteboekversie6.xls]Hoofdscherm!A1");"GO");"NO DATA")
Selection, Hyperlink, & GO button
Maarten --
Make first a 2-column list of the items of interest (like Gebouw verbeekstraat) and associated URL's (NOT the hyperlinks) in a woksheet named Admin. E.g.,
"Gebouw verbeekstraat,[ruimteboekversie6.xls]Hoofdscherm!A1;
Gebouw2,[ruimteboekversie6.xls]Hoofdscherm!A70;
Gebouw3,[ruimteboekversie6.xls]UitgeleendeBoeken!B18"
Select the cells of the first column and name it e.g., GEBOUWEN via the Name Box on the Formula Bar.
Select all of the cells of the 2-column list mentioned above (excluding any labels/column headings) and name it e.g., HPATHS via the Name Box on the Formula Bar.
Activate F34.
Activate Data|Validation.
Choose List for Allow.
Enter as Source:
=GEBOUWEN
Click OK.
Activate F34 and name it Selection via the Name Box on the Formula Bar.
Put a button in F35 whose name is edited such that it reads GO via the Forms toolbar.
In a cell, say, A2, in a worksheet that you could name Blackboard enter:
=HYPERLINK(VLOOKUP(Selection,HPATHS,2,0),Selection)
Start recording a macro with the name GO.
Navigate to Blackboard and just click what you see in A2.
Stop recording the macro.
Give a right-click on the GO button. Activate the option Assign Macro and assign the GO macro to this button.
Now, you can select some item from the drop-down selection list and just click the GO button which will navigate you to the desired location in the workbook.
Hope this covers what you have in mind.
=============
Re: Selection, Hyperlink, & GO button
Works great thank you alladin