Check Box Questions

[krickette]

OK, one more attempt at posting... it keeps logging me out at super inconvenient times.

So, I don't know anything about VBA. But I need this sheet done as soon as I can. I have a bunch of tags and I want to look at the errors for each of them. A friend of mine helped me make a macro to make the checkboxes, so that's good. Now I just need the rest of it done.

on the left will be the tag date and name.

So, I need to make it to where people can search for a tag based on what error they want to look at. Like "Oh, I only want to look at tags that have error3." and then they do something so that they can see a list of everything with that particular error.

So after much banging my head against my desk, I think the best way would be to somehow link every checkbox with a sheet... So that if something has error1, the tag name (and maybe the date as well) get copied to a sheet named "error1".

If you can think of a better way, that'd be fabulous, but otherwise if you have any idea of how to code that....i'll be your friend forever.

 

[Demosthenes&Locke]

Autofilter will allow you to pull everything out of a column containing "error3" from a dropdown list.

If you want an actual checkbox installed at the top of the page that doesn't bother with autofilter, and that's what your friends code creates, then we would need to know the names of these checkboxes, and whether you want it to use vbacode destructively (as in remove the stuff other than the results you want), create a new page with the results, highlight the ones you're wanting to see and hide the others, or sort based on what you want.

 

[krickette]

Thanks for the quick reply!
I could do either autofilter or a checkbox, I don't have any experiance with either, so I suppose whichever seems easiest to learn.
I don't think it needs to be super duper fancy I think sorting seems like the most difficult thing. A new page or hiding the ones I don't want would be ideal.

 

[krickette]

Also, I don't think a drop down list would work...unless I did 14 drop down lists that just said like yes or no. Each tag can have multiple errors.