Re: Input Box selection and file open

You could do something like this...

Sub OpenFile()
Dim lngCount As Long
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
.Execute
End With
End Sub

Look up the FileDialog Object in the help files as there are many properties you can use to customize how it functions.

Rick


"cottage6" <cottage6@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4D18A038-134D-40CB-B616-9A7FEFDBD982@xxxxxxxxxxxxxxxx
Hello everyone,
I'd like an Input Box that lets a user choose from a list of file names,
which would then go ahead and open the selected file. Do I need to start with
an input validation list box? I'm really unsure how to put this all
together, and any help would be very appreciated! Thanks and have a good
day.

.

Loading