I have a userform in which you have to fill many textboxes with numbers. I want to check the content of what has been just introduced as data. For this I wrote the following:
The problem is that you cannot use IsNumeric() with Controls because Value is not a valid property of Controls. How could I check if the current control has a numeric value?Code:For Each c In Controls MyName = c.Name If Left(MyName, 7) = "txtVare" IsNumeric(c) = False Then mensaje = MsgBox("xxxxx", vbInformation, "Error") Revision = 1 End If Next




Reply With Quote