View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillips Phillips is offline
external usenet poster
 
Posts: 48
Default Search or FIND on a userform.

I want to put a SEARCH or a FIND feild on my userform.

Here is what I currently have:

Private Sub CommandButton48_Click()
'MsgBox TextBox86
If TextBox86 < "" Then
Dim found As Range
With Worksheets("Master")
Set found = .UsedRange.Find(TextBox86, LookIn:=xlValues)
If Not found Is Nothing Then
MsgBox TextBox86 & " Found!"
Else
MsgBox TextBox86 & " Not Found!"
End If
End With
Else

MsgBox "Search Criteria was empty..."

End If

End Sub

How do I restuff all of the screen items? do I just reinitialize
everything? will it be on the right record?
Is there a way to get it to look even in hidden rows?
How do I do a find Next/Prev?

Thanks
Phil