In a blank worksheet, enter the valid names in a column, select the column
and name the selected range ValidNames.

The following code will validate the file name entered in the input box
against the list of names in the range named ValidNames

Dim wb As Workbook
Dim rng As Range
Dim strFileName As String
Dim strValidName As String
Dim i As Integer
Dim blnIsValid As Boolean

Set wb = ActiveWorkbook
Set rng = Range("ValidNames")

strFileName = InputBox("Enter the name of the file: ")

For i = 1 To rng.Cells.Count
strValidName = rng.Cells(i)
If strValidName = strFileName Then
blnIsValid = True
Exit For
End If
Next i

If Not blnIsValid Then MsgBox strFileName & _
" is an invalid file name."

--
Kevin Backmann


"Aziz Ahmedabadwala" wrote:

> I have a macro in which I use a input box which enables user to input the
> file name and saves the file.
>
> Can i restrict the Input box so that the user can put in only specific names.
>
> Aziz