Record time based on value being selected in list box

Hello,

I'm trying to figure out how to record the time that a user selects an option in a list box. I have two list boxes in their own sheet that get their info from two different worksheets.

I pass the listvalue to the worksheet, to select the item. But I need to record the time the listvalue changed on that worksheet. I put code below into a sheet, but it only works when I manually change the number in E4, not when you change the value of E4 (the listvalue) by using the drop down.

Please, please any help really gratefully appreciated!

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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