Changing the order in dropdown boxes?

[DennisE]

Gurus,

Has anybody worked out (or know of any references to) a good,
efficient way that would let users change the order of the items
appearing in dropdown boxes by sliding them up or down within
the list?

-- Dennis Eisen

 

[Tom Ogilvy]

I am not sure how you would see that as appropriate for a dropdown. Once
you select an item, the dropdown closes. This sounds like a maintenance
function - so you should probably manage the list/perform this function in a
separate listbox. If it is something the user needs to do, then, again, you
should use a listbox as the interface.

 

[count]

Hi Dennis and Tom Ogilvy!
I wrote something along the lines - it works but...- could Tom Ogilvy proof
read it? I'd be happy to release it to all, if kosher.
It is ValueMgr form with code associated with it.
Takes just one parameter i.e a global variable called ManagedRange as String
Form opens and deals with Named Range as per variable and offers:
0. Listbox with values - up 7 columns squeeze there OK
1. Up/down spin buttons to move selected item
2. Add New Button - to add more entries (input boxes will pop up)
3. Delete entry
4. Support for ranges up to 14 columns wide, input boxes will appear as
needed and captions will display whatever you placed in a row immediately
above Named Range.

The form is best invoked by DblClick event on a dropdown.
Please advise how to/if send it to you.
Paul