Error when searching for files

[scouse13]

Hi guys i am using the below bit of code, to search for files this works fine if i locate the file and press ok, this inserts the file path into textbox7 as it should, the problem i have if i press the cancel button when searching files, "FALSE" is entered in textbox7, how can i stop this happening so textbox7 is left blank

Thanks

Scouse13

[code]
Private Sub CommandButton6_Click()

Dim x As String
x = Application.GetOpenFilename
TextBox7 = x

End Sub
[code/]

[maclearyj]

Hi there. The getopenfilename will return False if nothing was selected (i.e. cancel was pressed). So,

Please Login or Register  to view this content.