VBA _Change() command Question

[D3Pratt]

When I use that function on a UserForm it executes the code immediately, not waiting for the value to be entered.

Thus the code executed that relies on the new values returns an incorrect value.

Example

A1 | 150
A2 | 100 <-- this is the value being changed to 300 with the Textbox
A3 | 250 = Sum(A1:A2)

Now with:

Please Login or Register  to view this content.

it copies over the value of 250 while I'm changing the value to 300...

Is there a way to get it to wait till I'm done changing the value first?

[shg]

Use the Exit event instead of the Change event.

[D3Pratt]

Hmmm. How would that look in the code?

I tried to add it in the way I would expect it to look... Got:

Compile Error:
Procedure declaration does not match description of event or procedure having same name

Please Login or Register  to view this content.

[shg]

Use the left dropdown to select the control of interest, and the right dropdown to select the event, and you'll get the correct signature for the function.

[D3Pratt]

Absolutely awesome! That did it.

TYVM!