Here's what I'm trying to do: I have a userform that contains a textbox and a commandbutton. The user would have the option of either to type the data required in the text box or to click the commandbutton to hide the userform and look for the data in one of the sheets of the worksheet. Once the desired data is found in the sheet, the user would click (or doubleclick) on that cell and then the userform textbox would be populated with the contents of that same cell. Is there a way to do something like this? I appreciate any help from the Excel gurus..

Thanks, Alex.