Want to create a file open box using a dialog box

[HpyTrvlr69]

I would like to create a file open box using a dialog box, but am not
familiar with VBA. Is there a simple solution which will allow me to change
the box header and place notes within the box itself?? Sorry for the
ignorance.

Truely,
Mindless Mike

 

[Harald Staff]

Hi Mike

Header yes, notes no:

Sub test()
Dim V As Variant
V = Application.GetOpenFilename(Title:="Go on pick one")
If V = False Then Exit Sub 'cancelled
MsgBox "You chose " & CStr(V)
'note that it doesn't open the file, VBA must open it if desired
End Sub

HTH. Best wishes Harald