Sir the clear find is disabled, i am not able to add more than one search text. also will it get added automatically in the QAT. Sir please help and guide apologize for the trouble, but I want to use, this tool is very helpful and very much needed, the built version is not that like yours one.
Hey TheStephens 👋! Hope you are well! I uploaded another version that has (hopefully) better error message if it hits one, let me know if you do and at what point you hit the error! For the QAT: I adjusted the uploaded one to not have that, accidentally had it saved to the QAT when I was testing it, and it saved with the add-in. If its still there, you can right click and remove control from the menu. For "not able to add more than one search text", what do you mean?
@@radsheets Yes Sir Thank you very much =) , I am doing well, also hope you are doing great, • Sir, its fine, it got added to the QAT, since I wasnt aware that it could be done with VBA, so I was asking. • Sir the error I am getting is 91, i.e i wrote in the search box "yes" and pressed enter, and the pop run time 91 comes up, but it does highlights yes. • Sir now when I try to click on clear find its disabled, so I manually enter another keyword, as Texas, when I press enter it gives debug error, on opening VB Editor, it highlights this line " If cFindManager.fHighlighting = False Then" and it does not highlights Texas as well, it shows still "yes". I am using MS365 Office Insider Beta Channel
@@radsheets Sir the new one I am downloading now, fingers crossed, I am highly excited to use this, in my excel I dont have any other Addins, except yours since it fulfils all my needs, till date whatever addins you have provided in the blog I have all of them. I love all of them, very much, use it everyday, Thank you so much. Let me try the new file.
@@radsheets Sir in the new one, I wrote "yes" in the search box and hit enter, it highlights the cells with "yes" and simultaneously pops the error window, so i click on debug which opens VB Editor to find this line is highlighted, " cFindManager.ribbon.Invalidate" Now I reset and go back to Excel and write "Texas" it doesnt highlights and instead i get a pop up, clicking on debug, shows this line " If cFindManager.fHighlighting = False Then"
WOW FANTABULOUS. Definitely use this my Excel GURU 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼
Thank you TheStephens! 🥰
@@radsheets Thank you very much Sir, for all this effort. Masterpiece Thanks for imparting knowledge =)
Sir, I get one pop up, Run-Time Error 91: Object variable or with block variable not set. how do i fix this
Sir the clear find is disabled, i am not able to add more than one search text. also will it get added automatically in the QAT. Sir please help and guide apologize for the trouble, but I want to use, this tool is very helpful and very much needed, the built version is not that like yours one.
Hey TheStephens 👋! Hope you are well! I uploaded another version that has (hopefully) better error message if it hits one, let me know if you do and at what point you hit the error! For the QAT: I adjusted the uploaded one to not have that, accidentally had it saved to the QAT when I was testing it, and it saved with the add-in. If its still there, you can right click and remove control from the menu. For "not able to add more than one search text", what do you mean?
@@radsheets Yes Sir Thank you very much =) , I am doing well, also hope you are doing great,
• Sir, its fine, it got added to the QAT, since I wasnt aware that it could be done with VBA, so I was asking.
• Sir the error I am getting is 91, i.e i wrote in the search box "yes" and pressed enter, and the pop run time 91 comes up, but it does highlights yes.
• Sir now when I try to click on clear find its disabled, so I manually enter another keyword, as Texas, when I press enter it gives debug error, on opening VB Editor, it highlights this line " If cFindManager.fHighlighting = False Then" and it does not highlights Texas as well, it shows still "yes". I am using MS365 Office Insider Beta Channel
@@radsheets Sir the new one I am downloading now, fingers crossed, I am highly excited to use this, in my excel I dont have any other Addins, except yours since it fulfils all my needs, till date whatever addins you have provided in the blog I have all of them. I love all of them, very much, use it everyday, Thank you so much. Let me try the new file.
@@radsheets Sir in the new one, I wrote "yes" in the search box and hit enter, it highlights the cells with "yes" and simultaneously pops the error window, so i click on debug which opens VB Editor to find this line is highlighted, " cFindManager.ribbon.Invalidate"
Now I reset and go back to Excel and write "Texas" it doesnt highlights and instead i get a pop up, clicking on debug, shows this line " If cFindManager.fHighlighting = False Then"
👍👍👍👍👍🙏
🥰👋