checkbox filters

luke w

Board Regular
Joined
Oct 23, 2002
Messages
53
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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,144,124
Messages
5,722,620
Members
422,448
Latest member
AugyIA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top