I have a demonstration workbook, "Scroll Worksheet List",
available for free upon direct request. The code modules are unlocked.
It scrolls a selected range (up or down) using a Spin button.
Please use your real name and provide your general location.

Remove xxx from my email address...
XX

--
Jim Cone
Portland, Oregon USA




"art"
wrote in message
I have a list of words of colors from cell A1 to Cell A5, the words, 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.
Please help.
Thanks.