The autofilter is disable using the userform
 

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

The autofilter is disable using the userform
 

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

The autofilter is disable using the userform
 

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

The autofilter is disable using the userform
 

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