populate textboxes from listbox dblClick

[nigelog]

Hi

I have a listbox "CPClst_1" which retrieves 65 column entries from a chosen name clicked upon

The same userform has textboxes CPCtxt_3 through to CPCtxt_10

I am trying to populate the textboxes with the data from columns 58 through 65 ( CPCtxt_2 needs to be Column1 but thats for later)

The data is a mixture of texts, numbers and data.

I cant seem to get the return I need...this is what I have tried

Please Login or Register  to view this content.

[cytop]

Assuming the ListBox is on a userform

Please Login or Register  to view this content.

Why do you loop

Please Login or Register  to view this content.

if you are only interested in values > 57?

You can loop

Please Login or Register  to view this content.

[nigelog]

Listbox is on the same userform "CPClst_1"

I have checked the number of listbox columns and correct, now looking at at anamolies in data but this amended code still doesnt return any values

Please Login or Register  to view this content.

The data is all date values except the first column so I moved code along a column to 59 to start populating at CPCtxt_4, but still no go.

Workbook attached. Userform is Update button from main menu

[cytop]

I can't really check this out (phone) - but it looks like you're reading up to column 65 from the listbox

Please Login or Register  to view this content.

Do you really have 65 columns in the ListBox??

If not then that should error rather than simply "doesnt return any values"

[xlnitwit]

Hi,

The index starts at 0 so you should be using

Please Login or Register  to view this content.

[nigelog]

@cytop - yes unfortunately 65 columns

@ xknitwit - spot on thankyou....