Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Allow users to select records, by their criteria.

  1. #1
    Guest

    Default

    Hi,

    Heres a strange request, but I hope someone can help:

    Need to be able to display change requests using USER input criteria in a form format.

    User chooses environment(4 possible environments), then chooses date range(from-to), and excel will display the matching record/s.

    Then the displayed records then must allow the USER to select individual records and display all information for the record.

    Thanks.

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Have you had a look at Excels "Auto Filters" found under "Data" on the main menu? I think they maybe well suited.



  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Thats very helpful, but is there any way of hiding the data and presenting it in a nicer format (like a form)?

    Thanks

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The 2 options would probably be a Data Form again found under data, or a Pivot table. The "Data Form" option would only be suited to a relatively small table.

    After these 2 you would be needing a UserForm in VBA.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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