subscript out of range combo box auto filter selection

**shaukat** · 12-16-2011, 07:14 PM

Dear experts,
I am working the following code. combobox1 has months jan~dec in it. combobox2 has years 2007~2009.upon selection change in combobox the auto filter should be applied according to given criteria in the code, but I am getting subscript out of range in final code line auto filter. Any idea?

thanks

Please Login or Register  to view this content.

**Steffen Thomsen** · 12-16-2011, 07:25 PM

Try referencing the sheet indstead og "Me.Listobjects"

**shaukat** · 12-16-2011, 07:39 PM

Dear Steffen
Thanks for your suggestion, I did it but same result. my sheet is attached.Please view it and give your advice

thanks

**Steffen Thomsen** · 12-17-2011, 05:21 AM

2 things

Please Login or Register  to view this content.

You need to change the format as seen here
And secondly, your table is named "Table2" not "Table1"

One last thing, i suggest you lock your comboboxes, else they will move with the autofilter

**shaukat** · 12-17-2011, 06:19 AM

thanks for correcting me.You solved my case. One thing how to lock combobox.

**Steffen Thomsen** · 12-17-2011, 06:21 AM

Right click on the combobox while in design mode and then press "Format control", here you go to the tab "Properties" and select "Don't move or size with cells".