Results 1 to 2 of 2

Thread: [RESOLVED] TextBox as Control

Threaded View

  1. #1

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Resolved [RESOLVED] TextBox as Control

    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:

    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
    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?
    Last edited by Fonty; May 24th, 2007 at 11:18 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width