[RESOLVED] compare listbox and textbox

[oh-sorry]

hi

in my project i have
a list box
a textbox
and a command button

in the listbox i have written some names like
jhon
eddie
martin

i want when i write a name in the textbox check the name is on the listbox and if the name is on the listbox then run the commandbutton

can any body help me

[akhileshbc]

Something like this...????

Private Sub Command1_Click()
MsgBox "hello"
End Sub

Private Sub Text1_Change()
If Trim(Text1.Text) = "" Then Exit Sub
For i = 0 To List1.ListCount
    If LCase(Trim(Text1.Text)) = lcase(List1.List(i)) Then
    Command1_Click
    Exit Sub
    End If
Next i
End Sub

[oh-sorry]

bro this code work bt

i want when i write a name in the textbox check the name is on the listbox or not and if the name is on the listbox then run the commandbutton if not dnt run the command button

[akhileshbc]

That is what my code is doing...
Have you checked it...????

[oh-sorry]

yes i hav check it bt i works when i type anything in the textbox :S

[akhileshbc]

I think, you are saying that, the code is executing when anything is typed into the textbox. Yes, it does..!!! When you type anything into the textbox, the program will check the listbox for any similar entries and if an entry is found, the button's click event is called....

Isn't this what you are looking for??? If not, then specify the details, clearly...

[oh-sorry]

ok i got it thanks a lot bro

[akhileshbc]

ok i got it thanks a lot bro

You are welcome...
If your problem is solved, then mark the thread as RESOLVED

-Best Wishes
Akhilesh