Want to create a file open box using a dialog box

  • Thread starter Thread starter HpyTrvlr69
  • Start date Start date
H

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
 
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
 
Back
Top