How to determine item selection in multi-select listbox without VBA?

[rizzo93]

I have two listboxes in my spreadsheet: one allows for multiple selections, the other only one. To be clear, this is not a userform, it's just part of the spreadsheet. Unfortunately, I cannot use VBA as a solution.

For the listbox that only allows for single selection, I can work out what the user has selected using the cell link in the format control.

But for the one that allows multiple selections, the cell link remains at 0 no matter what is selected.

Am I overlooking something or is this just how it is?

 

[Micron]

According to MS:
Note: The Multi and Extend options are only useful when you are using a Microsoft Visual Basic for Applications procedure to return the values of the list. Note also that the 3-D shading check box adds a three-dimensional look to the list box.

so I guess that's how it is, unless it's version specific. That article was for 2013 - 2021 and 365. You should probably include your version details in your profile/signature.

 

[rizzo93]

According to MS:
Note: The Multi and Extend options are only useful when you are using a Microsoft Visual Basic for Applications procedure to return the values of the list. Note also that the 3-D shading check box adds a three-dimensional look to the list box.

so I guess that's how it is, unless it's version specific. That article was for 2013 - 2021 and 365. You should probably include your version details in your profile/signature.

Thank you, @Micron .

 

[Micron]

You're welcome, and thanks for the recognition.