Find Folder Name VBA Code

I have tried several codes to get this to work with no success.
I have a folder that has subfolders (A-Z) that will mostly be formatted as "Name - P1111####" however sometimes it will just be "P1111####" ####= random numbers

I need a code that will use the value from a textbox in the userform (in this case "P1111####") search all the subfolders in the main directory and come back and tell me if a folder containing that text was found. Regardless if the name is there or not. *Bonus points for opening the containing folder "Not the file(s)*

If it's not found then advise that well.

Basically, the same way windows search does it when you type info into the search bar it just locates a folder containing that text regardless of extra text.

The folders have been Separated A-Z based on the first letter in the "Name" but really I don't care about searching the "Name" it's mostly there to help verify that the number matches the correct account.

To be honest, I had no idea... I was under the impression these 2 sites were completely separate. I am sorry.

No, and no I just follow common sense, and linking to where I also posted did not appear as common sense, but in future I will link cross posts. You can delete/close this thread anyways reddit provided help, and I'll probably stick with them from now on.