Hi Sea

'type this at the top of the module
Public xyz As String

'this is the function
Function getxyz()
xyz = InputBox("What is the filename that you are using?")
End Function


Cheers
JulieD

"Sea" wrote in message
...
Hi,

I need a message box function that I can just call from any module. All I
need it to do is ask the user for the filename they are using. Then when
user, types in the filename & clicks ok, it assigns to a Global variable. I
have the rest of the code out but I am struggling with this part. Doesn't
matter about the path as all files are in the same dir.
Any help would be brill Thks Sea