User Form TextBox Events

Hi folks,

I need some advice on coding a Textbox event.

I have a UserForm that utilizes the Change event of a Textbox.

The form goes through some validating before any calculations happen.

My problem is if the user wishes to backspace, clear or perform any changes to this textbox, it bugs out.

Here's the code:

Please Login or Register  to view this content.

I'm sure it's easy to fix but I've painted myself into a corner on this one.

I've included the file for reference

Thanks!

Mark

Do you really need the calculations to be updated for each keypress? Assuming not, I suggest you use the Exit event instead.

If you really want the Change event, then you should add a check to ensure that the Textbox actually contains data (which presumably should be numeric too).