| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| OldValue property | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
