+ Reply to Thread
Results 1 to 6 of 6

modifying code print out based on search on userform

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    modifying code print out based on search on userform

    hello
    I have this code doesn't work well it supposes copy to sheet(list) what I would after search in textbox what show in listbox then copy to another sheet and print out if there is alternative is ok
    HTML Code: 
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: modifying code print out based on search on userform

    I would after search in textbox what show in listbox then copy to another sheet and print out if there is alternative is ok
    Give this a go...Have amended all code...
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: modifying code print out based on search on userform

    wow ! you 've given me a big gift , just I face a problem not for your a new file , also is existed in my file when I search in textbox specific name it brings any word contains some letters , for instance when I search Ali it supposes bringing only name " ALI" , but the code brings any name contain the letters (A,L,I) in my case it brings also the name Khalid may you fix it, please?

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: modifying code print out based on search on userform

    Change this snippet...
    Please Login or Register  to view this content.
    To
    Please Login or Register  to view this content.
    And in CommandButton1_Click code...
    Change...
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Last edited by sintek; 12-17-2020 at 04:22 AM.

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: modifying code print out based on search on userform

    astonishing ! thank you so much for your assistance
    Last edited by ABDELFATTA; 12-17-2020 at 04:34 AM.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: modifying code print out based on search on userform

    .........................
    Thanks.gif

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] modifying code create summary customers based on column sheet to multiple sheets
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 12-01-2020, 09:37 AM
  2. [SOLVED] VBA Userform to search data in a table filtering results based on all search criteria
    By matt7416 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2020, 05:09 AM
  3. Help Modifying Some Code - Search Results Displayed as Table in Listbox
    By ajiljay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2017, 09:05 AM
  4. Code for search and print
    By Immortal2014 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2016, 03:06 PM
  5. Modifying VBA copy and paste code to search down rather than across
    By Stopwatch in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-07-2015, 11:45 AM
  6. [SOLVED] Need ‘Set Print Area’ Code for Dynamic Print Range based on Conditions
    By dosbirn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 12:13 PM
  7. Need help modifying code to search sub folders
    By davidsx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 04:48 AM

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