Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Most of the time, when I create a list box, and do a selection against it, all the selected values appear at the top, highlighted in green (in green because of the sheet theme I'm using).
However, from time to time, I create a list box, do a selection, and the selected items appear highlighted, but they're scattered throughout the listbox, instead of appearing at the top.
I've checked presentation-state-auto ascending, but that doesn't seem to make a difference. Is there some other place to control this aspect of the listbox appearance?
thanks,
Kevin
Hi
Proprties ->Check Fixed column and give 1 or 2
and remove the Auto ascending in sort tab.
Hope it helps