Fill out listbox with inputbox

Hello!

I have a database on excel sheet for devices: for each device I have 11 column ( ID, name, serialnumber, company number,date....).
I want to add on my userinterface a possibility to modify a device : the user click on the button modify on the userinterface, an inputbox appears where he can put the serial number of his device that he want to modify then when he click ok a userform with a listbox appears with all the device in the database that match with the serial number given by the user (because sometimes for different manufacturer we can have the same serial number) , so the user can click on the right device in the list box and in the same userform i put all fields of the device so he can modify the field of his choice.

I just want to know how with the inputbox we can select rows in the excel sheet (database)


Here is the code that I have written ( in the modify macro I have succed to select one device with the right SN but if there is 2 with same SN he only select one...)
Can anyone help me please?
Thank you for your help!VBA_Databasetrial.xlsm

Thank you very much for your fast answer!!! I'll try it and tell you about the result!! Thank you again!

Originally Posted by Sean Thomas

Hi,
i have added a button to you user interface called Find Serial.
this will then call the inputbox for a serial number.
This then loads a userform with a listbox of all found items.
if you select one and hit enter button it will give you the row number.
Hopefully you will be able to adapt this to use to pull up the range of data required into you textboxes to edit

I am not able to download the file!!! Can you send it to me by mail? [email protected]