Helpwith Userform syntax

Please Login or Register  to view this content.

Please Login or Register  to view this content.

AlphaFrog,
Almost, and I so appreciate it. Works perfectly if the address is already there when I select the LOT.
If not, then I have enter the address info, UPDATE, and re-select the LOT.
Is there a way to do it "on the fly", or maybe rather than disable TxtAWAYDT, clicking in it would trigger the event.
To be clear, there is not a requirement for the AWAY address unless I am entering the AWAY DATE or the Checkboxes.
Thanks.

Originally Posted by Len Silva

AlphaFrog,
Almost, and I so appreciate it. Works perfectly if the address is already there when I select the LOT.
If not, then I have enter the address info, UPDATE, and re-select the LOT.
Is there a way to do it "on the fly", or maybe rather than disable TxtAWAYDT, clicking in it would trigger the event.
To be clear, there is not a requirement for the AWAY address unless I am entering the AWAY DATE or the Checkboxes.
Thanks.

I'm flying blind here without the benefit of seeing your worksheet and user form. I don't understand what that means. I don't really know what "the LOT" is or the what you are trying to do at all.

What event are you trying to trigger?

CBLOT_Change and TxtAWAYSTR_Exit both call the sub routine Validate_AwayAddress
. I put it in a sub routine so you don't have to write the same code twice.

On another note: it is bad coding practice to leave On Error Resume Next active in your code. There are legitimate reasons to use that in some instances, but it doesn't apply here. All it does is hide errors, and you won't know what the problem is and how to fix it.

Please Login or Register  to view this content.