USERFORM: Move ListBox item up or down

Question

USERFORM: Move ListBox item up or down

Navigation

#1 by (0 votes)

0

I have a ListBox on a UserForm that reflects a list of the display order of items in a Dashboard. I want the user to be free to change the order of these items by moving them down or up in the ListBox, as shown in the figure:

Is there a way to do this without changing RowSource ?

excel vba listbox userform excel-userform

asked by anonymous 08.04.2017 / 14:40

1 answer

Active record, how to replace uniq with distinct correctly? Error retrieving a textarea by jquery

score 0 · Answer 1

My suggestion would be to edit the named range and re-create rowsource, so I think the user every time they use the tool will maintain the preference of the columns sequence and their form is updated on screen.