Conditional UserForm for opening specific folders

[Capulet]

Hi all,

I'm still very much a beginner when it comes to VBA but my intent is to find a way for a userform to access specific directories to allow the user to select a pre-sorted file.
Below is a very rough draft of what my userform would be displayed as:

In this example, the user would have the option of opening Folder1A(Opt1 and OptModifierA), Folder2A(Opt1 and OptModifierA), Folder1B(Opt1 and OptModifierB), or Folder2B(Opt2 and OptModifierB).

Can anyone assist me in how to write the VBA code for this? The final product will have more option buttons, but I want to solidify my knowledge with this example before I branch out. Thank you very much for your time and assistance!

Respectfully,

Cap

 

[Herakles]

Hi all,

I'm still very much a beginner when it comes to VBA but my intent is to find a way for a userform to access specific directories to allow the user to select a pre-sorted file.
Below is a very rough draft of what my userform would be displayed as:
View attachment 96225
In this example, the user would have the option of opening Folder1A(Opt1 and OptModifierA), Folder2A(Opt1 and OptModifierA), Folder1B(Opt1 and OptModifierB), or Folder2B(Opt2 and OptModifierB).

Can anyone assist me in how to write the VBA code for this? The final product will have more option buttons, but I want to solidify my knowledge with this example before I branch out. Thank you very much for your time and assistance!

Respectfully,

Cap

What do these represent in terms of folders?
Folder1A(Opt1 and OptModifierA), Folder2A(Opt1 and OptModifierA), Folder1B(Opt1 and OptModifierB), or Folder2B(Opt2 and OptModifierB)

Aee you looking to select multiple files or just one?

 

[Capulet]

What do these represent in terms of folders?
Folder1A(Opt1 and OptModifierA), Folder2A(Opt1 and OptModifierA), Folder1B(Opt1 and OptModifierB), or Folder2B(Opt2 and OptModifierB)

Aee you looking to select multiple files or just one?

Hi Herakles,
Those option/variables would ultimately define which folder/filepath to navigate to. The intent is to allow the user to see the files in that folder and decide which one to open. For this example I would defined the 4 folders as 1=“item1 orders received” 2=“item1 orders fulfilled” 3=“item2 orders received” 4=“item2 orders fulfilled”. Of course this is a poor example; however, it illustrates the general function required.

 

[Herakles]

Hi Herakles,
Those option/variables would ultimately define which folder/filepath to navigate to. The intent is to allow the user to see the files in that folder and decide which one to open. For this example I would defined the 4 folders as 1=“item1 orders received” 2=“item1 orders fulfilled” 3=“item2 orders received” 4=“item2 orders fulfilled”. Of course this is a poor example; however, it illustrates the general function required.

Why not just have a listbox with these options in it?
1=“item1 orders received” 2=“item1 orders fulfilled” 3=“item2 orders received” 4=“item2 orders fulfilled”

Selecting one will prompt the user for a file.

Do these folders share a parent folder?

 

[Capulet]

Why not just have a listbox with these options in it?
1=“item1 orders received” 2=“item1 orders fulfilled” 3=“item2 orders received” 4=“item2 orders fulfilled”

Selecting one will prompt the user for a file.

Do these folders share a parent folder?

It may seem obtuse; however, it is the way the organization would prefer it.

 

[Herakles]

It may seem obtuse; however, it is the way the organization would prefer it.

What will you do with the selected workbook?

Don't drip feed us.