>> Listbox OldValue

[Guest]

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

 

[Tom Ogilvy]

No, there is no oldvalue property. Youi would have to store it yourself
each time.