Hi,
I have a user form that reads a list of numbers and places them into a
combobox. Often I have to add a new number to the list and here is the
problem. If I type a new number into the list and run the form, the new
number is not displayed in the combobox.

I have found that if I drag the old number list down and increase the number
to the new one I require and then delete any intervening numbers that are
not required, the combo box will then read the new additional number.

I have tried formatting all numbers to the same format but it makes no
difference. It is no hardship for me to add new numbers by the drag method
but I don't know why this happens. Any ideas would be greatly appreciated.

Cheers,
Mickey