Hi everyone,
Currently I have a userform which entitles people to search up a street number and name, and click on a command button ("search") which runs a macro extracting data frome sheet 1 to sheet 2, provided it matches the criteria.

What I'm having trouble with is when you click search, the macro jumps between sheet 1 and sheet 2 several times running the filter. On sheet 1, when you select it, I automatically make it to bring up userform1, and whenever the search finishes, userform1 remains open, but I want it to close.
Now I have tried putting in userform1.hide at the end of the macro and that doesn't help.

Is there any way to disable the the sheet1's code userform1.show until the macro finishes executing, or something similar? I only want it to show up when you manually click the sheet, not when the macro accesses it.

Thanks,

Andrew G