[sassy2]

I'm writing a macro in Excel 2007 and would like the macro to pause for user input and then search for the word input by the user.

Any suggestions would be appreciated.

Thanks.

[Rollin_Again]

The easiest way to do this is to prompt the user with an inputbox. Can you post your existing macro code for us to look at?

Regards,
Rollin

[sassy2]

I will attach the workbooks I'm using and the code that I have so far which isn't much. The first workbook "Like Home" contains the macro. The second "LH Accts Rec" contains the accounts receivable records for each student. The third "LH Payment" is a receipt I want to use for payments received.

What I'm trying to do is open the receipt, enter the child's name the payment is for, open the accounts receivable document and lookup that child's record. I would then like it to automatically bring in the information from accounts receivable that it can (Parents Name, Balance Due, that kind of thing. The user will have to enter things like payment amount, payment method, etc.

The workbook "Like Home" that contains only one macro right now, but I removed several so as not to confuse things even more. I have macros that post the enrollment information to several other documents, but this one has me stuck. I just can't figure out how to search the accounts receivable workbook for the name input by the user.

Thanks so much for your help.

Sassy2