About Us

tracktraining

thanks a lot !
--
Learning

"Dave Peterson" wrote:

Maybe...

Option Explicit
Sub testme()
Dim myStr As String
Dim HowMany As Long
Dim myRng As Range

myStr = InputBox(Prompt:="For what would you like to search?")
If myStr = "" Then
Exit Sub
End If

With Worksheets("somesheetnamehere")
Set myRng = .Range("L:L")
End With

HowMany = Application.CountIf(myRng, myStr)

MsgBox "I found " & HowMany & " " & myStr & "'s"
End Sub

tracktraining wrote:

Hi All,

I am wondering if there is a way to use the user input as a search criteria?

Example: a message appear for the user "what would you like to search?",
then use that word in the following code : = countif (L:L, "[user search
word]").

thanks,
tracktraining.
--
Learning

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How get user input that can then be used in formula, as criteria?	jcoelho	Excel Worksheet Functions	2	July 1st 08 04:58 AM
Input one criteria to search in 5 fields	Fanny	Excel Discussion (Misc queries)	1	April 26th 06 04:11 AM
User form search criteria example	Tom Ogilvy	Excel Programming	0	July 27th 04 05:54 PM
Excel VBA- Get user input, search the for match, output to text file	gnileo	Excel Programming	1	January 8th 04 07:59 PM
CODE to select range based on User Input or Value of Input Field	Sandi Gauthier	Excel Programming	4	December 8th 03 03:22 PM

Menu

About Us