View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Marsh[_2_] Tim Marsh[_2_] is offline
external usenet poster
 
Posts: 14
Default Prioritised listbox

hope this question isn't too simple...

i have three objectives...

1) i want to populate a list box with values (coming from a userform) in a
specific order, am i right in thinking that if i use .additem it will keep
them in the order they're added (ie, it won't sort them alphanumerically)
2) i want to be able to prioritise that list if something is added in the
wrong place / order (like in the References dialog box in the VBA window -
using up/down spin controls?)
3) i want to use the newly ordered list, by assigning each of the list
values to individual flow diagram boxes, then link the with connecting lines

my main problem is #2 (moving values around in a list box), but if anyone
can help with any / all parts that would be great.

Many thanks.