VBA Excel open file per click

[Grz3siu]

Hello, I need to open the file via VBA. After clicking on the red label, I want the file to open. I want to enter the file paths directly in the VBA code. Do you have any suggestions?

 

[Yongle]

I cannot see your image clearly (but I think the label caption contains the name of a TIF file)
and you have not said what is supposed to happen after "I want the file to open" (is the image supposed to go somewhere?? etc)

Perhaps...
VBA should allow user to
- view an image file
- after clicking on a label on a userform
- where the label's caption is the image file name

If so, try this
- assumes all images are in the same folder
- caption contains the file name including extension

Code goes in userform module

Private Sub [I]LabelName[/I]_Click()
    Const Fpath = "C:\Folder\subFolder[COLOR=#ff0000]\[/COLOR]"                        [I]'end string with [COLOR=#ff0000]path separator[/COLOR][/I]
    Dim fName As String
    fName = [I]LabelName[/I].Caption
    Shell ("RunDLL32.exe C:\Windows\System32\Shimgvw.dll,ImageView_Fullscreen " & Fpath & fName)
End Sub