Hello Jadesky,
selecting a value in a listbox does not trigger an event.
But there is a workaround. Assign the listbox selection a cell link, say cell K1.
Every time you select a value in the listbox, K1 changes. But this alone does not trigger an event.
But if there is another cell that performs a calulation on K1, then you can use the Calculate event to see if the Listbox value has changed. The calculation of the changed value in K1 does trigger an event.
So, set up a dummy cell somewhere, with the formula
=K1*1
Then create a Calculate event macro along the lines of this:
The global variable ListValue will hold the old value of the ListBox cell.
Now, whenever the worksheet recalculates, the macro will run. If the ListValueCell is different from the previously stored ListValue, then the current date/time will be added to the TimeStampCell
Does that work for you?
cheers
Bookmarks