New to VBA and programming.
I'm trying to write a program where it asks the user for a location of certain files. I would like the drive and path to be an Option Explicit statement that is referenced later in the program in multiple places. Don't quite know if this is even possible? If not, any suggestions? Thanks in advance.
Hello b4tmast,
Option Explicit is a module level statement used to force explicit declaration of all variables in that module. This has no influence on an InputBox.
If you have code written, you should post it. Providing both before and after examples of what you want to do will help get you the answers you need.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
My apologies... This is what I was thinking about. Not sure about the syntax:
Is that syntax correct? I understand that an Option Explicit must be at the beginning of each module (do I repeat the same thing there?). But, what about for each Worksheet? Does the Dim cover all the sheets in the Workbook as well? Am I understanding this correctly?
Please Login or Register to view this content.
Thanks for your answer. I understand now. I've other questions, but, feel that they should be new threads. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks