Hi Dan,

The form presents a list with associated priorities as texboxes, the idea is
that the user can change the textbox value which will then reprioritize the
list based on the new individual textbox inputs.

Two potential alternatives come to mind:

1. Instead of reacting to the change event, have a separate 'Resort list'
button to do the reprioritisation.

2. Add a timer to the form (e.g. the IETimer.ocx available from the MS web
site), set to fire after (say) three seconds. Each time a text box is changed,
disable and reenable the timer. In the timer's event, reprioritize the list
then disable the timer again. The list should then update 'automagically' three
seconds after you stop typing.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk