Relative column number to listbox listindex

[Biffer]

Hi there

Using a multiselect listbox, I want to be return a value in the column relative to the listindex

i.e. I select the 4th and 6th items, a value is returned to D & F columns (I have 90+ items)

Please Login or Register  to view this content.

Any help appreciated

Thanks
Biffer

[MickG]

Try :-

Please Login or Register  to view this content.

[Biffer]

Hi Mick - thanks for this.

However, it is some type of loop I'm after, as the number of possible selected items isn't fixed. Could be one or many.

Any ideas

Thanks

[MickG]

Could you send a file with an example of your data showing expected results, from selecting from your Listbox

[Biffer]

Listbox Test.xlsm

Here you go

Many thanks

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[Biffer]

Thanks Mick - this is great.

One final thing is setting this to writing a new line for each selection(s). Rather than filling existing blanks

Columns A will always be populated with a reference number

Please Login or Register  to view this content.

[MickG]

Try :-

Please Login or Register  to view this content.

Regards Mick

[Biffer]

Fantastic - Mick thanks

[MickG]

You're welcome