Hello all:

I have a list of colors from cell A1 to Cell A5, Blue, Green, Red, Orange,
Pink. I made a userform with a list box containing the list mentioned. I also
added two command buttons, one is Move up, and one is Move down. Now I want
the user to be able to select from the list box one color and press for E.G.
command button "Move up", and the selected color should move up one row. And
if selected "move down", the selected color should move down one row. This
way the user can sort the list the way it needs to be. Can anyone help me
with this? I need this feature badly.

Thanks.

What happens to the other four colors? Do you leave the cell without a color
once you move a specific color up or down? What if the user is color blind?
Do you also have the color name in the cell for those folks?

"art" wrote:

Hello all:

I have a list of colors from cell A1 to Cell A5, Blue, Green, Red, Orange,
Pink. I made a userform with a list box containing the list mentioned. I also
added two command buttons, one is Move up, and one is Move down. Now I want
the user to be able to select from the list box one color and press for E.G.
command button "Move up", and the selected color should move up one row. And
if selected "move down", the selected color should move down one row. This
way the user can sort the list the way it needs to be. Can anyone help me
with this? I need this feature badly.

Thanks.

I am not putting in actual colors, I mean only the words of the colors. If
Green is second in the list and the user wants to move it down, then green
becomes the third in the list and red second and so on.



"JLGWhiz" wrote:

What happens to the other four colors? Do you leave the cell without a color
once you move a specific color up or down? What if the user is color blind?
Do you also have the color name in the cell for those folks?

"art" wrote:

Hello all:

I have a list of colors from cell A1 to Cell A5, Blue, Green, Red, Orange,
Pink. I made a userform with a list box containing the list mentioned. I also
added two command buttons, one is Move up, and one is Move down. Now I want
the user to be able to select from the list box one color and press for E.G.
command button "Move up", and the selected color should move up one row. And
if selected "move down", the selected color should move down one row. This
way the user can sort the list the way it needs to be. Can anyone help me
with this? I need this feature badly.

Thanks.