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

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" <(E-Mail Removed)> wrote in message
> news:ED9E5CAB-E140-4E5E-A436-(E-Mail Removed)...
> > 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
>
>

delete this:-

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

which is the last code line in sub Button8_click

"Joseph Pagan" <(E-Mail Removed)> wrote in message
news:92142C94-DCD5-4ED1-849C-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:ED9E5CAB-E140-4E5E-A436-(E-Mail Removed)...
>> > 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
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:92142C94-DCD5-4ED1-849C-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:ED9E5CAB-E140-4E5E-A436-(E-Mail Removed)...
> >> > 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
> >>
> >>
>