View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sea Sea is offline
external usenet poster
 
Posts: 3
Default Message box- Assign a file name to a variable, from user input

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. Doesnt matter about the path as all files are in the same dir.
Any help would be brill Thks Sea