View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Glen Mettler[_4_] Glen Mettler[_4_] is offline
external usenet poster
 
Posts: 70
Default How to get a return value from a user defined function

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