LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find record by multi criteria in userform MP Excel Discussion (Misc queries) 0 November 3rd 08 04:01 PM
IF with Search/Find??? TotallyConfused Excel Worksheet Functions 5 August 1st 08 10:05 AM
Can Search find 2 or more "/"? Wind54Surfer Excel Discussion (Misc queries) 2 February 22nd 05 04:31 PM
Search and find Rick K Excel Programming 1 August 21st 03 04:15 AM
How can I find a handle number of controls on Userform? sjoo Excel Programming 1 August 4th 03 10:21 AM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"