VBA Code to Filter dates with command button

[Angnz]

Hi

Can anyone give me a simple VBA code to filter dates with a command button

I have a worksheet and I want to use a command button to:

""Only show rows that have Jan 13 in Column G"" ( 01/01/13 - 31/01/13)

Then once I have used information I want to push the button again and all rows return to sheet

Thanks

Angela

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Angnz]

Hi
I found this code that works if I use a number in the 4th to last line but if I put a date in the line it doesn't work can someone give me a fix for 4th to last line

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.

[watersev]

hi Angela, option, please check attachment, press Filter button

PS. You need to use special tags for posing VB code on the forum. See Forum Rules for details

[Angnz]

Hi

Sorry about the tags will do from now on.

This works perfect, if I want to filter different month what do I change on the code (say only show Oct 13) Hide all other months
Also how do I add the command button to this code I tried putting it in a command button code and it didn't work

Angela

[Angnz]

Hi

I have worked out both issues thanks for a great code

Angela

[Fotis1991]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.