Auto filter off

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I want to turn the auto filter off (or show all) on a worksheet whenever a
userform is initiated. Is it possible to write code in the userform
procedure to achieve this?

GK
 
The AutoFilter property toggles, so you need to check its state using
AutoFilterMode:


'turn on autofilter
If Not Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").Range("A1").AutoFilter

'turn off autofilter
If Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").Range("A1").AutoFilter
 
Thanks for the solution Steve.

GK

Steve said:
The AutoFilter property toggles, so you need to check its state using
AutoFilterMode:


'turn on autofilter
If Not Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").Range("A1").AutoFilter

'turn off autofilter
If Worksheets("Sheet1").AutoFilterMode Then
Worksheets("Sheet1").Range("A1").AutoFilter
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform within a userform ... 7
inconsistent dir() behavior 1
How to enumerate buttons on user form 2
Macro to print specified range of several work sheets 2
Hidden sheet bleeds through 3
Worksheet appears briefly before UserForm opens 4
Dim an array from a filtered Range 1
Lock userform for editing 2

Back
Top