Populate Textbox from offset cells when selecting listbox item

Apologies if this is already here, but I have searched and cannot find a solution for my situation!

I have a userform with a listbox showing 3 columns. I would like to populate a text box with data when I select a row in the listbox. Columns 1 through 3 are shown in the listbox. When I click on an item I want column 4 from the row to be shown in the textbox.

The listbox is populated using this code: -

Please Login or Register  to view this content.

When I click on an item in the listbox this code is executed: -

Please Login or Register  to view this content.

The above code also populates an image holder with a photo from the filepath of the worksheet matching the name of the item I click in the listbox. The problem I'm having however is with this line: -

Please Login or Register  to view this content.

All I get is a copy of the text shown in the listbox printed in the textbox. It appears to be ignoring the offset. It doesn't matter what I change it to!

Ideally what I want is: -

For columns 1 - 3 to show in listbox and when I click on it, column 4 (not shown in listbox) to populate textbox1.

Col1 Col2 Col3 Col4(not shown in listbox)
Name DOB Gender Address

Many Thanks in advance!

Thanks for your reply, would this work however when the listbox is not being populated with that data? I'm only populating it with 3 columns?

Sorry, but confused (very new to this!), but I'm not using RowSource to populate the listbox. I'm using a defined Name Range in the worksheet which I then define in the code "NameFound". This is a defined range of 1 column in the worksheet. I am still able to populate the listbox with as many columns as I want, but just use the defined range when searching it.

Even why I try this way, I still just get a copy of what the first column in the listbox says, printed in the textbox: -

Please Login or Register  to view this content.

Hi,

Thanks for that, I've tried doing as you said but I am still only seeing the data from column 0 being printed in the textbox...am very puzzled by this! I've tried changing column numbers and offsets etc, but still no joy. Am I missing something?! I would post the entire workbook for you to look at, but as it is an already populated sheet with sensative data I am unable to do so. Any other ideas?

Ok cancel that! I found the issue. There was some rogue code further down where for some reason under textbox1 change there was code saying TextBox1.Text = ListBox1.Value.....(!) Sorry for wasting your time! But one further question, will using the method above result in large amount of data being put in the memory when I have over 500 rows of data being called?