Solved: Find and select a cell based on user input

[John8669]

I am trying (unsucessfully) to create a macro that opens an InputBox and allows the user to enter a document name. Then I want to select the cell in a single column that contains that input. There are no duplicates.

Thanks

[mikerickson]

This might work for you.
[VBA]Sub test()
Dim userInput As String
Dim rowFound As Variant
Dim dataColumn As Range

Set dataColumn = ThisWorkbook.Sheets("sheet1").Range("A:A"): Rem adjust

Do
userInput = Application.InputBox(userInput & "Which document do you want?", Type:=2)
If userInput = "False" Then Exit Sub: Rem cancel pressed

rowFound = Application.Match(userInput, dataColumn, 0)

If IsError(rowFound) Then userInput = "That document not found. Try again." & vbCr
Loop Until Right(userInput, 1) <> vbCr

dataColumn.Parent.Activate
dataColumn.Cells(rowFound, 1).Select
End Sub[/VBA]

[John8669]

Thanks for the help...

It does not seem to find the document, which is a number not text, when I change "Dim userInput As String" to "Dim userInput As Integer" I get "Type Mismatch" on this line

If userInput = "False" Then Exit Sub: Rem cancel pressed

[mikerickson]

The looping structure et.al is dependent on userInput being a string. Leave userInput as string and change

[VBA]rowFound = Application.Match(Val(userInput), dataColumn, 0) [/VBA]

[John8669]

Works Like A Charm!!!!

Thanks Mike....

[mikerickson]

You're welcome.

[mdmackillop]

Hi John,
If your question is answered, please mark it solved using the Tread Tools dropdown
Regards
MD