Textbox Exit Event Cant not be trigger

**stewegg** · 03-22-2012, 06:14 PM

Hi,

I have three text boxes on my worksheet.
They are for Start Time, End Time and Time Half Way between the start and end time.
I want the third text box to calculate the half time when both start time and end time are entered.

I tried the code below, but it won't tiger. Please help.

Please Login or Register  to view this content.

Thank you very much,

**Leith Ross** · 03-22-2012, 06:19 PM

Hello stewegg,

This should work...

Please Login or Register  to view this content.

**Dennis7849** · 03-22-2012, 06:32 PM

If the end time is in textbox3, then use TextBox3_AfterUpdate event.

It tested this with good results

Please Login or Register  to view this content.

TextBox1 has the StartTime
TextBox2 has the EndTime
TextBox3 has the MiddleTime

**stewegg** · 03-23-2012, 11:48 AM

Hi Dennis,

It only works when I click "run" in VBA.
It doesn't run automatically.
Am I missing something?

Thank you very much

**stewegg** · 03-23-2012, 11:49 AM

Hi Leith Ross,

Thank you for your help.
It only works when I click "run" in VBA.
It doesn't run automatically.
Am I missing something?
Also, I can not tab through or use enter to go to the next text box for some reason...

Thank you very much