I have a very plain spreadsheet with one macro that returns a list of dates (when a given hymn was used) using the hymn number entered in D3. My problem (which is purely cosmetic) is that, as far as I know how to set these things up, I now have to click on cell D3, type in the hymn number, press "Enter" or in some other way have Excel "accept" the data for that cell, and only then click on my little button that runs the Advanced Filter macro. I would like that to be a one-step process - either type the hymn number, then press the "Enter" key and have the macro run (when focus shifts from D3 to D4) or be able to simply type in the hymn number and then press my macro button. As it stands right now, if I click the button before I press "Enter," the text-editing mode of cell D3 is still active, and nothing happens. I hope this made some sense, and I deeply appreciate any assistance!