Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for your help,
I have used IF functions for use with the checkboxes but get an error with my current code. Can anyone help? Thanks in advance, Ben Private Sub SearchButton_Click() Range("B3:L10").Select 'Set Field Dim myField As Integer If DateOp = True Then Set myField = 1 ElseIf TourRef = True Then Set myField = 2 ElseIf Country = True Then Set myField = 3 ElseIf Place = True Then Set myField = 4 ElseIf Spaces = True Then Set myField = 10 End If Selection.AutoFilter Field:=myFeild, Criteria1:=Search.Value, Operator:=xlAnd End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
Autofilter to search characters that begin with "* " | Excel Discussion (Misc queries) | |||
Windows search in Excel with autofilter | Excel Discussion (Misc queries) | |||
using autofilter to search 2 columns | Excel Programming | |||
Use sheet name as search string or autofilter criteria | Excel Programming |