Separate Button for Auto Filter Selected Range

  • Thread starter Thread starter Nasir Naqvi
  • Start date Start date
N

Nasir Naqvi

Hi,

How can we creat separate button in MS excel for selected range class in auto filter. If we click on button then only selected range class appears. Should we write script on Macro in VB.

For example,

Button Name "XYZ"

Column A (with Auto Filter)
ABC
XYZ
DEF
XYZ

If we click on button "XYZ" then cell "XYZ" instead of "ABC" & "DEF".

Regards

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
IF? you mean that you want to filter the range by the selected column then
you would probably want a double_click event macro to do the autofilter
 
Create button using Control toolbox, right click on button and select
"view code", then enter the following

Private Sub ButtonXYZ_Click()
Columns("a:a").AutoFilter Field:=1, Criteria1:="XYZ",
visibledropdown:=False
End Sub

If you wanted to autofilter a specific range, you could replace
columns("a:a") with a range, such as range("a1:a5")
The visible drop-down is the autofilter arrow that appears in the first
cell in the range, it can be toggled on/off with true/false.

Regards,
Andrew J Armstrong
 
Back
Top