• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Type to filter after sort not working

    Thank You , Well Noted !!
  2. J

    Type to filter after sort not working

    Thanks for the Code but it sorts complete sheet i only want to sort the visible row in filtered sheet for example if data is filtered with Column E / Model / C 200, then i want to sort the data by Column B / WIP NO , is it possible. Thanks
  3. J

    Type to filter after sort not working

    I need that text box to search any required text.
  4. J

    Type to filter after sort not working

    When I sort the file for example by column E 'Model' then , search box is not working and screen freezes.
  5. J

    Type to filter after sort not working

    Testbox1, has filter as you type code. check attached file before sort their is no issues. where testbox1 is working for example if you type S 500 you can see the filter.
  6. J

    Type to filter after sort not working

    vletm Please find the attached file i inserted the code but still type to filter search box is not working
  7. J

    Type to filter after sort not working

    Dear Experts , please help !
  8. J

    Type to filter after sort not working

    @PCI - I tried but still same
  9. J

    Type to filter after sort not working

    Hi All, I have an excel file where type to filter search box VBA is running, when i sort the data then type to filter box is not responding and complete sheet is getting highlighted , can you please fix this problem. Thanks Find attached both files after sort and before sort.
  10. J

    Redo/Undo

    Thank You all for suggestions.
  11. J

    Redo/Undo

    I have an excel file where i has a VBA for highlight active cell row and column and on this file Redo/Undo function is not working can you please provide me a solution on this. Thanks Attached is excel file.
  12. J

    Text box search filter

    Thanks for helping me out, It works faster now.
  13. J

    Text box search filter

    Previously I shared with little data as a sample but now when i compiled the file ( see the attachment) which has total 7000 and above rows and now search is very slow and screen freezes for few seconds , for example if you search word ''Released'' then you will see the search is very slow and...
  14. J

    Text box search filter

    Thank you soooo much !! Works perfectly.
  15. J

    Text box search filter

    @p45cal Only one issue i encountered the filter drop down button gets invisible after search, so what is hapeening i have to clear the comlete filter where i loose the filtered column. can filter drop down be visible always so that without clear i can do filter on top of another filtered column...
  16. J

    Text box search filter

    @p45cal Thank you for your thoughtfulness and appreciate your time on my concerns , this file works perfectly, Must say awesome work !
  17. J

    Text box search filter

    Dear All I have an excel file where i have a text box with VBA code to filter the search. This excel has 4 column B.C.D.E.F I have 2 Concerns first the text box searches in column B only, i want to change code to search in complete sheet for example if i search S 400 which is in column E...
  18. J

    Limit the characters per line

    Sorry i will take note of your advice !!
  19. J

    Limit the characters per line

    Thank you so much with this code my query is solved.
  20. J

    Limit the characters per line

    Actually i have to copy this text and put it in our company program when i copy and paste this text then it is showing complete text without line break , for instance i copy this text and put it in notepad no difference.
  21. J

    Limit the characters per line

    Sorry regarding column adjustment no i do not want to wrap text as per column adjustment i need line break after every 30 characters regardless column width.
  22. J

    Limit the characters per line

    Yes if the last word is long and cannot fit in 30 characters then should go to next line . Thank you
  23. J

    Limit the characters per line

    Hi All I want line break after every 30 characters in excel, attached is example file where i have done manually line break by ALT+ENTER Can someone please provide me the VBA or some kind of formula to do it automatically, Appreciate your response
  24. J

    Toggle Protect

    Dear Narayan Working perfect now, Thank You so much :)
  25. J

    Toggle Protect

    Please find attached screenshot
Back
Top