List box sort

A

art

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.
 
J

JLGWhiz

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?
 
A

art

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top