Hello, its been a while since I have been here but I am in need of assistance. First off I haven done this in a while so to say that I am rusty is an understatement. What I am trying to do is create a form that allows for input to be entered, a button to be clicked and a search of a sheet in 2 columns of the sheet to be searched and the results of the row to be displayed on the search form. I know its a lot but any starting point would be appreciated. Thanks!
Copy the code you're using to the clipboard. Then click Code on the post menu. In the overlay paste your code. Correct any tab issues to make it more readable. Click Insert Code Snippet Now your code is formatted in the message field, and you can add any comments that are relevent. If the worksheet set up is important then uploading a screenshot of the worksheet and maybe a description will do in most cases.
Okay so here is the code I am trying to use. I have it to where the code will at least look in the sheet but it wont display the results even if found. I am working on finding an inventory solution. This will be coupled with a barcode scanner which I have already worked out. Thank you for your assistance.
Dim FindString As String
Dim Rng As Range
FindString = InputBox("Enter a Search value")
If Trim(FindString) <> "" Then
Set Rng = .Find(What:=FindString, _
If Not Rng Is Nothing Then
Application.Goto Rng, True
MsgBox "Nothing found"