I need help coming up with a macro that opens a userform that allows the user to search through multiple configurations of a part for the configuration he/she needs. Right now this particular part has close to 50 different configurations. Instead of having someone have to search through each one, I need a better way for them to query the right size prt. I know the basics of VBA but I am struggling on this. If someone can get me close to what I need, I can probably finish it. It would also be helpful for the macro to start when the prt file is opened.
This is part of the configs they have to choose from.