Sir, thanks for the new trick for searching data, magar sir 2 se 3 second ke difference ke liye bahut sara code likhna pada, advance filter men bahut kam code aap ne use kiya, and both results are the same only difference time 2 to 3 second. Lekin isme bahut sari nayi chiz sikhne ko mila. Thanks again for your great effort to develop day by day with new and never seen before tricks.
Yes, but apne ye bhi dekhna hai ki future me advance filter ke data koi koi agar by mistake change hota hai to problem hoga aur sath hi sath agar kabhi aap dusre data base se data ko connect karte hai to problem aayegi
Amazing sir you are genius sir agar hum date k bajaye or ksi criteria say search kare like invoice number ya mobile number ya name tu woh kse kare gay just hum drop down list say select kare or text box main enter kare or results extract hojaye same sped main.
@@vbAFun Dear Sir, I have developed a jewelry software using multiple sheets & hide some important sheets to avoided user watching, where i have used "Select " hide sheet but when I run macro coming errors due to hide sheet, if i unhide sheet than no errors. There is any solutions that macro run easily with hide sheets without errors ? Hope will you guide us improving talent
@@vbAFun Dear Manoj Sir, I am watching your valuable & amazing trikes to learning & developing skill I have also apply in my software your trikes regarding License & Expiry date of software but all these are offline, I have delivered software but some of them are being complain that computer formatted or need install another computer while I don't know what is true So you are requested to develop something how to surrender license online from previous computer if user want installation on another computer & software also stop automatically if license expire as currently many ERP software available in the market. Thanks for your supports & guidance
Hi first of all i am Ajay Kumar from VBA FUN Question is good as i have already said in earlier video that if you want to activate on another system you have to contact your vendor for reactivation
hello sir app ne offiline chat application pe Frame pe automatic scrollbars vertically enable kiya tha it is very Useful but kya ListBox Pe Vertically Automatic Scrolling Enable Kiya Jasakta he, agar yeh hota he to Solution Dijiyega, kiuki data herneke liye babar Manual Scroll Karna partahe please help me
sir unique function not having office 2007 to office 2019 . i observed it have only office 365 and office 2021. plz make unique function code to use whose not having this versions....kindly do that sir ....thanks
आदरणीय गुरुजी प्रणाम, मेरी 1 समस्या है की मैं जब मैं डाटा सर्च करता हूं तब कुछ डेट का डाटा तो सर्च हो रहा है पर डेट चेंज करने के बाद subscript out of range का error आ जाता है। अग्रिम धन्यवाद।
Dear sir When I enter the date by vba form after insert the date new method not working after again the edit date in excel sheet then it's working what is the problem pls help me Error camming runtime error '9' Subscript out of range error camming pls sir help I humbly request you ! I hope u will help!🙏🙏🙏🙏🙏🙏
As i said in the video that if u are adding item in list box using AddItem then you can not add more that 10 column. For that you have to use array variable method. So for that I just uploaded a video in last week . Another for date picker please check the criteria carefully for that. Because that error should not be incurred
@@vbAFun Sir... I used array variable only but total row showing more than actual data bicoz of that Subscript outoff range error occurred. I used the new trick code step by step...Pls help
@@BIKASHKUMARSINGH-y9t see if you follow the step from the new video then it should work properly. But still if u are facing any issue please send screenshot of error and where you get the error mean line of code
sorry sir I am distubing your more I am so sorry about that I have one more question pls help me . I want to search data only date to date for this what we can do.....? In mehtod (Array method )