ListBox keep sort order after selection?

[prees959]

Hi,  I have a Month listbox which is sorted using

=match(Month, 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

in the expression box.  If a month is selected can the sort order be kept?  At the moment, if a month is selected it moves to the top of the listbox.

Many thanks,

Phil

[felipedl · Accepted solution]

Hi Phil,

On the Sort tab of the list box, use the Auto Ascending in state.

Example with Ascending (keeps the selection on top):

Auto (keeps the selection order):

Felipe.

[prees959]

Thanks very much!

[Kushal_Chawda]

one more option

Try uncheck all sort option, keep only expression, with below expression

=match(only({1}Month), 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

[felipedl]

Glad it helped Phil .