Using VBA to search a range, and return a result
Posted by Daniel van Vliet on November 26, 2001 10:14 PM
What I am trying to acheive is attaching a code to a command button, such that when press it will request the user to find a value, the user enters the vale, press's ok, excel will locate the value, and return/action another cell.
Basically I want to search a range for specfic value, using an input box, and then preform an action
This is what I've got so far:
Range("a1:d10").Value = FindText = InputBox("Search for: ")
The above will give me the inputbox asking to search, butI can't get it to actually find the value in the range and action it.
Tks in advance for your help.
Daniel van Vliet.