Choose Image in Excel VBA

[tjvance]

Hello everyone, I am currently creating an entry form in VBA. I have the image box and I have set up a command button to select the image from my computer storage. However, this is only able to select the image I have told it to select. I need to be able to select different images every time I use this form. I wanted to add a range (Example: in the text box I want to be able to type in a number "0001" and it be able to add the image that corresponds to the number. The formatting for my numbers are 24-0000 so if the "24" can be added to the code I can then select any "0000" number is how I want it to work) in this, however, I do not know how as I am a rookie when it comes to this.