Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,570
- Office Version
- 365
- 2016
- Platform
- Windows
I am looking for support with a vba solution to the following task.
I wish to present to the user a list of appropriate file names in a defined directory that start with the string "Active". That list is then numbered and presented in a inputbox for the user to select the one file name based on it's corresponding number.
The inputbox contents would look like this ...
Please select the number of the file you wish to open.
[1] Active322
[2] Active14
[3] Active
The variable for the inputbox is ui1
Of course, some error checking to ensure that only a number within the range of menu numbers is selected.
I wish to present to the user a list of appropriate file names in a defined directory that start with the string "Active". That list is then numbered and presented in a inputbox for the user to select the one file name based on it's corresponding number.
The inputbox contents would look like this ...
Please select the number of the file you wish to open.
[1] Active322
[2] Active14
[3] Active
The variable for the inputbox is ui1
Of course, some error checking to ensure that only a number within the range of menu numbers is selected.
