I delete the line but give a error when i use the find button.

"Patrick Molloy" wrote:

delete this:-

If Sheet1.AutoFilterMode Then Sheet1.Range("A7").AutoFilter

which is the last code line in sub Button8_click

"Joseph Pagan" wrote in message
...
i post here my code :
http://www.mrexcel.com/forum/showthread.php?t=393635

I too long to post here but there you can download or only see the code.
Thanks.

"Patrick Molloy" wrote:

I'm not sure what the issue is. we really need to see your code
using the FIND method in a userform does not have any direct affect on an
automatic filter.

(Excel 2003)

"Joseph Pagan" wrote in message
...
My problem is with the autofilter
What is my problem?
when i use the find button in a userform created in VBA, the autofilter
is
disable automatically in the worksheet without my intervention the
close
button disable too the autofilter in the worksheet.
What is my question?
How i can Troubleshooting my application to never disable the
autofilter
when the users use the userform especially the find button and the
close
button