+ Reply to Thread
Results 1 to 14 of 14

Help with Filtration Form

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Help with Filtration Form

    Hello guys\
    \
    I found that form but when I want to amend it, I had some troubles\
    \
    \
    \
    No filtration was done\
    \
    \
    \
    \
    Please HELP, the form attached
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help with Filtration Form

    AutoFilter works fine so I'm not sure what you mean
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    When i click the button "Commandbutton1", nothing appear in the listbox2

    ---------- Post added at 01:31 PM ---------- Previous post was at 12:27 PM ----------

    The second listbox does not work,
    any HELP Ya Regala

  4. #4
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    UP

    Up

    UP

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help with Filtration Form

    Here's my version.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    Hi royUK

    thanks for ur hard work, but u destroyed the structure of my form and tables

    please i need a help in my file

    the problem is : the 2nd listbox doesnt filter the data which selected according my criteria, 2nd listbox doesnt work

    please check my code and review

    ThanKs

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help with Filtration Form

    Quote Originally Posted by Mamud View Post
    but u destroyed the structure of my form and tables
    I haven't used your sheet. I posted an example for you to adapt for your needs.

  8. #8
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    Hello

    any Help will be appreciated ya Regalla

  9. #9
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    UP

    Up

    UP

  10. #10
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    UP

    Up

    UP

  11. #11
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    so you cant do what i request in my attached file, please

  12. #12
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help with Filtration Form

    I'm not here to do all the work for you. Are you trying to learn VBA or just looking for some-one to work for free?

  13. #13
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Help with Filtration Form

    Mr royUK

    I think there's no use from these words u said, the attached file have all codes I need, reviewed and amended

    all I request, to check the code of the listbox2, coz it's not work with me.

    I didn't request from u to do all the work for me as u said, please take care from ur words next time

    THANKS

  14. #14
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help with Filtration Form

    You accused me of messing up your code.

    I've provided an example that you can adapt.

    Your form does not have working code.

    Good luck - I won't be helping you

+ Reply to Thread

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