Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Separate Button for Auto Filter Selected Range
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Separate Button for Auto Filter Selected Range
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 -- Don Guillett SalesAid Software <Nasir Naqvi wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Separate Button for Auto Filter Selected Range
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When in filter mode status bar doesn't show range of cells filted | Excel Worksheet Functions | |||
lose selected range when I right click | Excel Worksheet Functions | |||
Advanced filter a dynamic date range | Excel Worksheet Functions | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) |