hi everyone
I am stuck!! I have been able to use checkboxes as filters in excel. I have a seperate checkbox filter for each manufacturing process for a particular steel. when someone wants to find a steel that can be bent/welded/blasted..etc. they can select all the checkboxes that apply and the excel spreadsheet is filtered accordingly. What I can't do is get it to publish the results to a listbox I have.
any ideas?
here is my code
'this filters the bend material
Private Sub chkbend_Click()
If chkbend.Value = True Then
Worksheets("Sheet2").Range("F1").AutoFilter _
Field:=6, _
Criteria1:="y"
Else
chkbend.Value = False
Selection.AutoFilter Field:=6
End If
End Sub
I am stuck!! I have been able to use checkboxes as filters in excel. I have a seperate checkbox filter for each manufacturing process for a particular steel. when someone wants to find a steel that can be bent/welded/blasted..etc. they can select all the checkboxes that apply and the excel spreadsheet is filtered accordingly. What I can't do is get it to publish the results to a listbox I have.
any ideas?
here is my code
'this filters the bend material
Private Sub chkbend_Click()
If chkbend.Value = True Then
Worksheets("Sheet2").Range("F1").AutoFilter _
Field:=6, _
Criteria1:="y"
Else
chkbend.Value = False
Selection.AutoFilter Field:=6
End If
End Sub