I have a listbox which is populated with rows of information from a spreadsheet called Eque2_Contracts. Column B to be precise.
I now want to pull in data from other columns that are along the same row in the spreadsheet as the selected info/line in my listbox. I am going to use that data to populate a few different text boxes on the same form.
So for example, if I select a row in my listbox, it will find the data from column G of selected row (same spreadsheet) that is along the same row as listbox selection. I will then need to put that CELL data into a text box to display.
For example I may want to put other cell data along the same row in another text box on the same form and maybe a couple of other columns cell data same row also. (In other words I will need to add other cell data along the same row into different text boxes on same form)
ANY help would be much appreciated.
I now want to pull in data from other columns that are along the same row in the spreadsheet as the selected info/line in my listbox. I am going to use that data to populate a few different text boxes on the same form.
So for example, if I select a row in my listbox, it will find the data from column G of selected row (same spreadsheet) that is along the same row as listbox selection. I will then need to put that CELL data into a text box to display.
For example I may want to put other cell data along the same row in another text box on the same form and maybe a couple of other columns cell data same row also. (In other words I will need to add other cell data along the same row into different text boxes on same form)
ANY help would be much appreciated.