+ Reply to Thread
Results 1 to 13 of 13

Hide All Rows and Display only one row based on User input

  1. 01-20-2016, 10:34 AM #1
    neetag
    neetag is offline
    Registered User
    Join Date
    01-19-2016
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Hide All Rows and Display only one row based on User input

    Hi,

    I am very new to VBA and I have a requirement to hide all rows when a user opens an excel and based on an input box(employee id) ,show only the row of the employee id provided in the input box.

    I am able to write the codes separately for an input box and hide all rows but I cant put everything together.

    Appreciate if I could any pointers on how to implement this code in vba?

    Thanks

    Neeta
    Reply With QuoteRegister To Reply
  2. 01-20-2016, 10:38 AM #2
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Hide All Rows and Display only one row based on User input

    Welcome to the forum
    As for your request please attach a sample workbook ..
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-20-2016, 10:46 AM #3
    neetag
    neetag is offline
    Registered User
    Join Date
    01-19-2016
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Re: Hide All Rows and Display only one row based on User input

    Hi,

    Thanks for your quick reply.I have attached the document on which I am trying to implement this logic.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-20-2016, 11:58 AM #4
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Hide All Rows and Display only one row based on User input

    Try this code
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-20-2016, 12:06 PM #5
    troilii
    troilii is offline
    Registered User
    Join Date
    11-14-2014
    Location
    Estonia
    MS-Off Ver
    2013 Office for Mac
    Posts
    31

    Re: Hide All Rows and Display only one row based on User input

    Quote Originally Posted by YasserKhalil View Post
    Try this code
    Please Login or Register  to view this content.

    That code looks awesome, but where should the ID Code be hosted?
    Reply With QuoteRegister To Reply
  6. 01-20-2016, 12:36 PM #6
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Hide All Rows and Display only one row based on User input

    I didn't get your question ...
    But as I got your words, The ID codes would be in column A
    Reply With QuoteRegister To Reply
  7. 01-20-2016, 01:27 PM #7
    neetag
    neetag is offline
    Registered User
    Join Date
    01-19-2016
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Re: Hide All Rows and Display only one row based on User input

    YasserKhalil

    Thanks for your inputs.I will put this code in my excel and get back to you for any questions.
    Reply With QuoteRegister To Reply
  8. 01-20-2016, 02:03 PM #8
    neetag
    neetag is offline
    Registered User
    Join Date
    01-19-2016
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Re: Hide All Rows and Display only one row based on User input

    YasserKhalil

    The code you sent works perfect but I have 2 issues still


    1.The first time I open the sheet,I can see all data.I need the data to be hidden first and based on the input box condition it needs to show the data
    2.When I enter any value which is not in the list,it shows me all the data available.

    Can you help me with these issues too?

    Thanks
    Reply With QuoteRegister To Reply
  9. 01-21-2016, 03:59 AM #9
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Hide All Rows and Display only one row based on User input

    Ho Neetag
    As for first point : you can add this line in thisworkbook open event
    Please Login or Register  to view this content.
    The same thing with point two , I will add the same line in the second part of the IF conditional
    I
    Please Login or Register  to view this content.
    In satndard module
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 01-22-2016, 10:19 AM #10
    neetag
    neetag is offline
    Registered User
    Join Date
    01-19-2016
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Re: Hide All Rows and Display only one row based on User input

    Thanks YasserKhalil.It worked.
    Reply With QuoteRegister To Reply
  11. 01-22-2016, 10:43 AM #11
    YasserKhalil
    YasserKhalil is online now
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Hide All Rows and Display only one row based on User input

    You're welcome. Thanks for the feedback and for the rep points
    Glad I can offer some help

    Please mark the thread as solved
    Reply With QuoteRegister To Reply
  12. 11-19-2020, 02:48 AM #12
    risma75
    risma75 is offline
    Registered User
    Join Date
    11-19-2020
    Location
    Malaysia``
    MS-Off Ver
    Office Pro Plus 2013
    Posts
    1

    Re: Hide All Rows and Display only one row based on User input

    How to get it autorun when opening a workbook? I'm using Excel 2013. It just shows blank table after being opened and had to run the macro manually from Developer tab.
    Last edited by risma75; 11-19-2020 at 03:20 AM.
    Reply With QuoteRegister To Reply
  13. 11-23-2020, 08:44 PM #13
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,642

    Re: Hide All Rows and Display only one row based on User input

    Administrative Note:

    Hello risma75 and welcome to the Excel Forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert # of Rows based on User Input
    By afpilotb1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2014, 11:40 AM
  2. Hide/unhide rows based on form input
    By Nicolas Mous in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2014, 10:49 AM
  3. Hiding rows based on a user input box
    By jshaw82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 06:34 PM
  4. [SOLVED]Hide Rows and Columns Based on User Input
    By thesteve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2013, 01:32 PM
  5. [SOLVED] Macro to search through dates and display results based on user input
    By Alan668 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-22-2012, 12:40 PM
  6. Delete rows based on user input
    By Militia in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-10-2009, 06:33 AM
  7. unhide/hide rows based on value input
    By whoosh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2009, 11:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1