Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks very much!
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')
Glad it helped Phil .