Hi, I have a listbox on a worksheet. When a user selects an item in the list,
I want to know the previous value.

Using the _Click and _Change events is too late to trap for the previous/old
value. In Access a control has two properties .Value and .OldValue. Is there
an equivilant in Excel?

Any ideas or suggestions appreciated. :-)

Many thanks, Jonathan