The autofilter is disable using the userform

  • Thread starter Thread starter Joseph Pagan
  • Start date Start date
J

Joseph Pagan

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
 
Back
Top