Results 1 to 5 of 5

[VBA] Filtering Data from Excel worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-26-2008
    Location
    Singapore
    Posts
    18

    [VBA] Filtering Data from Excel worksheet

    I have a excel data which is looking like the attachment image.

    I want to add one function into the userform which can let the user to select and filtering the date according the age. Referring to the attachment userfrom (Two options: 25 - 29 years old and 30 years old and above)

    Inside my data excel sheet, there are date of birth coloumn. Can anyone show me how should i write the command to filter according the age
    (P/S: The D.O.B Column was format as Date and i have attach the excel file as well)
    data.png
    dobform.png


    Thank you in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1