Please explain this basic code - New to VBA

[cdmse]

Hi-

I'm just stating out with VBA assigning basic macros to buttons and such for now.
I was wondering if somebody could explain this code to me. It automatically updates an advanced filter based on the given criteria. (Code from extended office)

Please Login or Register  to view this content.

Also, how do I post code so it shows in a better format?
Thanks!

[mjr veverka]

Please Login or Register  to view this content.

This above macro is started each time any cell is selected, then the range "A5:D21" is filtered, based on the conditions from range "A1:C3" (without any unique values as a result).
It would be better, e.g.:

Please Login or Register  to view this content.

This above macro will work only after you changing the criteria (in range "A1:C3"), one by one or only one.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)