Compile Error

[Damian37]

I'm trying to add a validation on a box within a userform that I am working on. I want to make sure that if the user selects the value Direct within a combo box within the userform, they will be unable to leave the TxtAmt box empty. They will have to enter a numeric value within the box if Direct is selected. I thought if I added

Please Login or Register  to view this content.

Users would no longer be able to leave the amount box blank. Unfortunately, I cannot even get to the testing phase, because I encounter a Compile Error: Expected expression, and the <> operator is highlighted. I also tried to write it using

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

But that didn't work either. Can anyone tell me what I am doing wrong? I added the if statement at the end of the sub-query. Here's the entire sub-query:

Please Login or Register  to view this content.

I appreciate any and all help. Thanks!

[shg]

<> is a comparison operator; = is both a comparison operator and an assignment operator, depending on context, and assignment is what you need here:

Please Login or Register  to view this content.

[stnkynts]

Why are you triggering it as this event?

Please Login or Register  to view this content.

This line is problematic (and incorrect)

Please Login or Register  to view this content.

This isn't really doing much of anything. All you are doing is changing txtAmt.Text. Maybe this:

Please Login or Register  to view this content.

[Damian37]

Why are you triggering it as this event?

Please Login or Register  to view this content.

This line is problematic (and incorrect)

Please Login or Register  to view this content.

This isn't really doing much of anything. All you are doing is changing txtAmt.Text. Maybe this:

Please Login or Register  to view this content.

Thanks Stnkynts, that last example worked.