Search using a Userform
Posted by Paula on May 24, 2001 12:34 PM
Excel 97: I'm a novice writer of macros/visual basic. I have created a userform that will allow the user to enter in the part number, quote number, etc. that they want to find(8 columns of options, undetermined number of rows) . I then have an OK button which would launch the search or a CANCEL button to exit the search. After performing the search, I would like the cell that the item is located in to be the active cell. What's the easiest way to do this? Also, is there a way that I can use a "Find Next" button to find the next occurence of the item? (A macro that would open the Find option on the Edit menu would work for me if there's a way to do that.)