View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Technique to move (reorder) items in Listbox

Selecting an item and using a spinbutton?

just remove the item and add it back at the appropriate location (one
position up or down).

--
Regards,
Tom Ogilvy

Stuart wrote in message
...
I'm sure I've seen somewhere (but cannot locate now)
code that will allow the user to change the order of
items in a listbox.

I want to use this code to allow a user to change the
tab order of worksheets, and thought I could populate
the listbox with the sheet names.

Can anyone help, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.586 / Virus Database: 371 - Release Date: 12/02/2004