Excel Macro Search Box
Posted on 2014-07-16
I'm a advanced novice Excel user trying to run a substantial sales operation. I have a worksheet that has approximately 5000 Customers so, 5000+ rows and approx. 30 columns of data. Every time I have to look up a Customer, I am using the Filter to uncheck "All" and look down the list for the particular record. This is nerve racking as it can take 30 seconds or more to look up a particular record in column A.
What I'm looking for is a small piece of VBA Code that can assign a "key" such as "L" (for look up) and up pops a box that seeks the character string typed into the box focused on either a particular column, say "A" or has a option to "search all" which would be the entire sheet.
Can I get some help with this? I think it's rather simple for someone who knows VBA. I have the skills to integrate it into my worksheet...but simply need help with the lines of code, search algorithum and probably the form that needs to come up in order to perform the search (with link to the assigned key (such as Ctrl+L -- for Look Up).
Much thanks in advance,