close

I want to create a command button that will filter specifice product. Could
you please give me sample macro that filter data.

Thanks.

Sub test()
'
' test Macro
' Macro recorded 11/01/2006 by Kevin M
'

'
Columns(quot;Your range of dataquot;).Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=quot;your filter criteriaquot;
End Sub

All this does is invoke autofilter and then selects a range for the user.

HTH
Kevin M

quot;Conditional Formattingquot; wrote:

gt; I want to create a command button that will filter specifice product. Could
gt; you please give me sample macro that filter data.
gt;
gt; Thanks.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄