+ Reply to Thread
Results 1 to 22 of 22

Search data with textbox and combobox

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Search data with textbox and combobox

    Good night!
    I added two text box.

    Now I need to do a search on the worksheet and play into the ListView.

    I need to check for dates and hours client but I'm not getting.

    See the code and the attachment.
    Who helped me with most of the friend was the author of the code jaslake
    Please Login or Register  to view this content.


    Thank's
    Attached Files Attached Files
    Last edited by marreco; 03-13-2012 at 10:38 AM.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Good morning!
    Any idea how to help me?
    Thank you!

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    I'm not able to adapt the text box.

    If someone can help me thank you!

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Any idea how to help me?
    Thank you!

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Any idea how to help me?
    Thank you!

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    You'll need to explain what you're after...you're current Agendamento worksheet makes no sense to me. You have one date 3/6/2012 with an hour of 8:00, a date of 3/7/2010 with an hour of 8:15, etc, etc.
    What are you after? What will be entered in TextBox 1 and TextBox2?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  7. #7
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    I'll type a date and another date in textbox1 textbox2.

    I lisview returns to the client that is between two dates in the textbox.


    Before I typed the hours and the client.

    Now I enter the dates and times and the customer.

    Thank you

    If you do not understand tell me that try to explain again

  8. #8
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    I honestly don't know if I understand. It seems as if you're saying "Let me pick a range of Dates then give me the Client and Hours between that range of Dates". If this is the case, I'm not certain you're current file can give us those results. I'll look at it.

  9. #9
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    hi my friend.
    I'm bad to explain and I do not know any English.

    Forgive me, I'll try again.

    example:.
    criterion 1
    I need my textbox, look in column A (txtbox1 = = 10/11/2012 to txtbox2 = 02/03/2012).

    criterion 2
    The combobox will look in column B (ComboBox2 = 08:00 to combobox3 = 11:00).

    criterion 2
    The combobox will look in column C (ComboBox1 = Maria Bonita).

    So this code below, will have to return the ListView, the criteria above.

    I tried daptar but my mistake is to this part.
    Please Login or Register  to view this content.
    Thnak you!!

  10. #10
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    You're English is fine...I THINK I know what you want to do. I don't believe your file has the information you're looking for. I'll try to demonstrate this with an example. It may or may not be tonight. I WILL get back to you.

  11. #11
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Stay comfortable to answer, I'll wait for your reply.
    Thank you for a while.

    Thanks anyway!

  12. #12
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco

    I'll develop the code that does this...I truly don't understand
    example:.
    criterion 1
    I need my textbox, look in column A (txtbox1 = = 10/11/2012 to txtbox2 = 02/03/2012).

    criterion 2
    The combobox will look in column B (ComboBox2 = 08:00 to combobox3 = 11:00).

    criterion 2
    The combobox will look in column C (ComboBox1 = Maria Bonita).
    May or may not be tonight.

  13. #13
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Hi.
    See the picture.
    See what I typed ns textbox to bring me the data based on the day 17 to day 30.

    So should I return dates 17/03/2012 and 18/03/2012

    But the data came from 07/03/2012 to 18/03/2012.


    thank you
    Attached Images Attached Images

  14. #14
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    The file you posted in Post #1 does not match the file that displays in Post #13 in the Erro.jpg. Please post your current file (with current code).

  15. #15
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Hello, it is the only file I have.

  16. #16
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco

    Post the file that resulted in Erro.jpg. The code in that file is different...I'd like to see it.

  17. #17
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    I need the filter to get the information from the textbox in this case was placed an apostrophe.
    If you do not understand my explanation, you need not waste your time with this, anyway I am very grateful for the help, thanks!
    Attached Files Attached Files

  18. #18
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    This file has code different from the first file...works better when we're looking at the same thing. Try replacing the offending line of code with this
    Please Login or Register  to view this content.
    Let me know how it goes.

  19. #19
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    Hi jaslake.

    Sorry not work!

  20. #20
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    It seems to work for me screen shot.jpg
    Attached Files Attached Files

  21. #21
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Search data with textbox and combobox

    It really works!
    I just need to reverse the months to the day.
    In Brazil the dates work well.

    Brazil dd / mm / yyyy

    English MM / dd / yyyy.

    Thank you!

  22. #22
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Search data with textbox and combobox

    Hi marreco
    You're welcome...glad I could help.

+ 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