How to get a return value from a user defined function

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

Using Excel 2002
I am using the FileDialog sub provided in the help to open a file.
I want to call that from another sub and return the selected filename.
I change FileDialog from a sub to a function but I can't get it to return
the name of the selected file.
Here is what I want to do:

MySub()
MyPik = FileDialog("")
If MyPik = "" then
exit sub
end if
If MyPik <> xxx then
exit sub
else
openfile
endif

I can't get the FileDialog function to return the file name

Glen
 
Back
Top