Advice on Non Active Userform triggering event

Hi Guys

I need some advice on how to handle a specific issue...
I have a system that logs work done by staff for specific Client functions during a day...
Scenario as follows...
Client phones in and needs something done...
At that exact moment the User selects the client from Combobox1...A textbox is populated with actual time...
After evaluating the client request, The user then selects the task from Combobox2

After completing the client request, the user then pushes stop which logs the info to sheet, however, if nothing takes place within a prescribed time...i.e No movement on userform or no populating of data to sheet, I need Public commandButton code to be executed...

I have tried placing activation.wait code within combobox2 but this did not work...

Any ideas how one would handle this...

You can make use of the OnTime method.

Standard code module

Please Login or Register  to view this content.

Userform1 module. Form has label, textbox, listbox and button.

Please Login or Register  to view this content.

Show the form and press the button. If you do not enter the other controls within 3 seconds it will display timeout message.
If when you show the form you press the button and then within 3 seconds enter the textbox the Still active message should display.

You will need to reset the mLastActive variable for each control.

Andy this is absolutely fantastic...Will implement into my form and am certain it will work well...

Hi Andy

I have implemented your code...fantastic...Only one hiccup i can't figure out...I have attached my file for your perusal...
Would you be so kind and check the following for me...Think I am missing a reset somewhere...

On opening the userform pops up...

User selects a Client
User selects a Activity...Now your implemented code activates...My setting will be 10 min...currently 5 seconds
After time period, the info is written to sheet and a message box pops up...Form clears and becomes ready for new activity

Another use is as follows:

User selects Client then selects activity...now a phone rings and user must answer...he then selects a new client, code then automatically populates sheet and prepares for next activity selection....If no activity...your code runs...

If user finishes activity he selects stop which populates sheet...Form clears and prepares for next client...Unless he does nothing then your code runs...

Somewhere between user selecting a new client something is not resetting as it runs code that checks for empty activity box...I just get figure out where...If you have a moment, pls be so kind and see what I am missing...

Not to worry Andy...Found my error...Had to add red part...
Tx again...much appreciated...

Please Login or Register  to view this content.