Running macro problem.

[jjohnson88]

I'm trying to get a macro to work but I'm having some problems. I made a test macro that looks for specified text in a field and pops up a message box. But if I'm not in the specific box that has that text, it won't work. If I am in that box, it will work and pop up the message box. Why is it doing that? I want to be able to search an entire column of data and have it export the rows with that specified text to a different table. Is that possible?