vbax53854_v2.xlsm
Here you go.
This adds a command button to load the form.
The close button code is added.
I hid the listbox that loads the sheet values
and added a text box to let the user type their own number,
then the search button starts a looks for a match of the input and the hidden listbox values first column.
then displays the matches adjacent columns as requested.

Hope this helps
- I also removed the drop down from the sheet so it works the same way as the new form...

-mark