VBA Code to automatically update label in the userform

**sn152** · 05-09-2014, 05:31 PM

Good Morning All,

I have a user form with a textbox and few labels and also some few other textboxes. When I enter a value in textbox2 it automatically updates the labels and other textboxes. But when I delete the value entered in the textbox2 it is not removing the data in the labels and other textboxes.

Please help me on this..

Thanks in advance...

**MarvinP** · 05-09-2014, 05:34 PM

What is the code you have behind the userform and the controls you are updating? Please supply the sample workbook along with what you are trying to accomplish. It is much easier to help when we can see what you have and what you are trying to do.

**sn152** · 05-09-2014, 06:22 PM

Please see the Userform - "EWS" in the attached file.

Thank you!

**MarvinP** · 05-09-2014, 06:29 PM

Hi,

It looks like you have code behind the Userform and behind Textbox2. You have an event behind textbox2 that reads:

If IsNumeric(Me.TextBox2.Value) Then

Which will only fire if what you've typed in the textbox is numeric. When you delete anything in the textbox it no longer is numeric and your code is skipped over.

This seems like the problem you are describing. You may need to add some code that is something like:

If IsNumeric(Me.TextBox2.Value) ="" Then