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

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

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

Thanks,

Andrew

--
carlito_198
-----------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php...fo&userid=2139
View this thread: http://www.excelforum.com/showthread.php?threadid=46672