Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown list select event.
I have a custom dropdown data validation, but need to capture the point at
which the selection is made by the user in order to measure the time between this and a comanndbutton press. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown list select event.
in a module add a PUBLIC variable as DOUBLE
set the value of this using the sheet's change event to trap the value changing use the cutton's code to get the elapsed time... here's a sample sheet code (rigth-click the sheet tab & select view code Option Explicit Public t As Double Private Sub Worksheet_Change(ByVal Target As Range) t = Timer End Sub Private Sub CommandButton1_Click() MsgBox Timer - t End Sub this sets the time for ANY changes...so you'll need to test if the cell that's changed is the cell containing the validation etc etc...but this is just an exampel "PBcorn" wrote: I have a custom dropdown data validation, but need to capture the point at which the selection is made by the user in order to measure the time between this and a comanndbutton press. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-select from a dropdown list | Excel Discussion (Misc queries) | |||
select cells in dropdown list by keyboard | Excel Discussion (Misc queries) | |||
Problem with Data Validation Dropdown List / Worksheet_Change Event | Excel Programming | |||
select multiple items from a dropdown list | Excel Worksheet Functions | |||
MS Bug? Data validation list dropdown with Worksheet_Change event | Excel Programming |