Validation Check - UserForm

akhlaq768 · #1 (**permalink**) 02-26-08, 10:41

Each time a the user enters a Unit Number for each questionnaire, can i set a validation check to say that Unit Number entered has been already entered...

how easy can this be done?

The user enters the Unit number into UserForm1!TextBox1, once submitted it goes into Sheet1, column A.

Please see attached the UserForm

karthic_85 · #2 (**permalink**) 02-27-08, 07:44

t is the textbox1 value

call below fn with t as input

Code:

Sub execute(t As String)
      If t = "" Then

      Else
   
   
          ActiveWorkbook.Sheets("Sheet1").Activate
          Range("A1", "A65536").Select


                    Do Until IsEmpty(ActiveCell) = True
          
                         If ActiveCell.Value = t Then
                          MsgBox ("already exist")
                         End If
       
  
                            ActiveCell.Offset(1, 0).Select

                        Loop
  
        End If

        End Sub

akhlaq768 · #3 (**permalink**) 02-27-08, 09:32

thanks... will give it a go

Internet Services

Web Development

Digital Marketing

Consumer Tech