Multiple Choice from List Box

[alis88]

Hello

I have a list box with various items in it. When an item in the list is selected, the content is transferred to the cell to the left of the column.

Multiple items can be selected, and a list is built up in the cell beside it.

This is all done using a macro.

My question is, I have two list boxes on the same worksheet and the same thing happens with each list box. I need to specify that this function only occurs with one of the list boxes.

The code is as follows:

Please Login or Register  to view this content.

Can you please help me with how to specify the cell range and not all cells?

The required list box is K5-K500 and these choices are displayed in J5-J500.

Thank you in advance.

Alis

[royUK]

can you attach an example workbook/ have you actually got listboxes or Data Validation lists?

[alis88]

Please see the attached worksheet.

When I select an item from K5, it is displayed in J5 (as desired) but this also happens with H5 and G5 (whereas in this cell I just want a normal validation list box in H5 and nothing to happen adjacent to it).

Thank you again.

Alis

[royUK]

There is no listbox on the sheet, you are using Data validation. You really should learn the basics before attempting VBA, if only to explain your self properly. Try this amended code which limits the action to Column K

Please Login or Register  to view this content.

[alis88]

Thank you SO much!

You are an angel!!

Yes, you are right - I do need to learn the basics. I am an extreme beginner and am very new to macros etc.

I can't thank you enough.