Thanks for the suggestion. Have amended the spinbox to
MoveUp and MoveDown buttons. Can get sheetnames
into the listbox.

When back in the module, how do I relate the position in
the listbox to the sheet's tab index (I presume that is the route) ?

Regards.

"Tom Ogilvy" wrote in message
...
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






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