Listbox OldValue
 

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

Listbox OldValue
 

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

--
Regards,
Tom Ogilvy

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