Use listbox selection and match function to populate controls on userform from dataset

Hi everyone.
I am back now with another request for help with my Update/Edit procedure.
I am using a userform(frmSearch) to search for a record in the dataset (NumbersDB) to UPDATE the record for now. The user form has a Listbox with textbox and Combobox controls on it. This part is working correctly but it is not really what I want to achieve..

I am looking for help with the following:

1) When I make a selection (Dble_Click) in the Listbox I want to highlight the correct Row on the Sheet(NumberDB) AND populate the controls DIRECTLY FROM THE Sheet(NumberDB) and NOT from the Listbox. I know you must use the Match function for this but I do not know how to do this.
2) I also want to show the selected Row number from the Sheet(NumberDB) in the txtMatchRowNo. Currently, I am showing the SNo in the Dataset and this will differ from the Row number in the Sheet as the dataset is starting on Row 6

I am including my workbook for easy reference.
Thanking you all in advance for helping me.

Why do you want to retrieve the values from the worksheet? That doesn't seem very efficient to me? It is better to use a table (listobject) to collect data. Why do you use an 'inputform' and a Userform. It is better to arrange everything via a Userform.

Very sound advice from @Vraag, make life easy for yourself, there is no need for complex search routines, there is a direct link between the listbox.listindex and the data row of a table - do not bother renaming textboxes etc., leave the default name - place in the same sequence as your table columns and with three or four lines of code you can add/edit/update/remove with ease.
The link below is one of my recent contributions on a similar case.

https://www.excelforum.com/excel-pro...ml#post5582780

I have added a pdf with the code fully indented for ease of reading.

@torachan, how do you export the code to a .pdf so neatly?

@Vraag, using an addin named "VBAcodePRINT" I think it cost approx £20 as a download 6 -7 years ago.

@DawidV, I was putting forth what in my opinion was best option, I would be doing you a disservice by assisting an inferior approach.

The column count of a listbox only becomes problematic if you use 'rowsource' or 'additem' methods to populate it - the 'additem' is a throwback to early VBA and as its name implies it is used to add item singular, and is very inefficient when handling mass data, the less read/write to the sheet you do the speedier your program becomes.
e.g. remove all formula/calculations/formatting from the sheet - you do not want your sheet unnecessarily calculating at every cell data change.
action calcs etc., at the point of data insertion will speed up your workings.
I have attached a search demo that i put together some time ago - basically the same subject, a poster on this forum having difficulty with listbox columns, wanting to keep stock figures with over twenty plus stores - some of the search methods may assist you.