Dear Sir, I am very glad to have completed the project by watching your video and learned a lot. I am from Bangladesh, watching all your videos with great interest and learned a lot, thank you very much. thank you sir.
Sir I am a senior accountant of various firm I work with tally and other software like Marg and a local software in foxbase made but I can't satisfied and want a complete software with you
Thank you sir, coz of your efforts our doubts are cleared. I m waiting for this video since long time. I will work on my project n if any assistance is required I will contact. I learnt from your channel successfully on how to create inventory management system but still I am not getting in right way will do after this video. 🙏🙏
Sir, I am a regular follower of your genuine channel. I am very much thankful for efforts and contribution.Sir, I had a query: How to turn a technical product information to pdf file, the software must have the option to enter its parts number with total parts calculation and allow indication with an arrow through software format and later it can be saved as pdf file as engineering product and parts information sheet. Awaiting for your kind response. Thanks & Regards.
Hello Sir Thanks for such a great knowledge. It was really helpful. I have one query that whenever i run this VBS file from Another Application the User form appears on background and it need to be come in front above all applications. Is there any way by which we can bring this user form above all applications ?
Sir Mera ek question hai jaise hum application mein activation code laga dete hai aur kisiko trial ke liye application dete hai toh kya hum usse mein kuch cheeze hi access karne de sakte hai baki sabhi disable ho Jaye sirf usse dekhe features but usse access na kar paye aur yeh Sara process access database mein ho sakta hai jo activation code hai woh access database mein generate ho date and all? Agar ho sakta hai toh aap iss per video bana sakte ho?
Ek aur yaad aa gya woh access sirf wo hi kar paye jo trail activation code mein hum usse application mein use karne ki option de aur Jo disable ho woh sirf dekh sake agar uss per woh click kare toh usse message aaye ki iss feature ke access karne ke liye licenced version purchase karna padega woh chahe kisi bhi disabled feature per click kare MSG yeh aaye
Good evening sir. Sir we have a instrument whose data file export in CSV format to usb, when this usb connect to pc this data file convert in excel format. My question is that is there any method that we can make a such data file non editable.?
sir thank ap ne 1st question ka answer dia main ne b puchha tha ap se, ItmList update kr di hae, but eik problm pehly se ye b aa ra tha k agr main ne product 6 ko scan kia hae tou wo listbox mein 6 row mein ja ra, agr product 1 ko scan kia tou wo listbox ki 1st row mein ja, Gros amount net payment working but if i scan item 20 then wo item listbox mein nai show ho ga but calculate sahi kary ga...
@@vbAFun sir main wo file download kr chuka hun, which is working 100%, main apko messenger mein video shot send kr chuka hun, time mily tou dekh lejye ga, and im trying to solve tha problm as well...
Sir Thanks a lot for this useful video... I have one query... I in this method, we disabled Micro and then run the program, and its working fine BUT I have created Progress Bar and used it in For Loop Function. After Disabling Micros.. Progress Bar Not working. Sir Please help to solve this problem. Almighty Bless You. 😊
Sir hume kisi bhi tareke se exe file install karwa sakte hai bina kisi popup window ke mujhe selenium library install karna hai but Mai chahata hu ki samane wale user ko install hota huya na dekhe
Sir apne meri request accept nhi ki, POS ya kisi bhi user form ka data kaise excel table range me enter kr sakte with all feature like ( edit delete search update )
Hello sir namaste .. I am from Nepal . Can you please help me with the list box ... I want to make list box show the latest entry after entry .. ... I hope you understood my question ❤❤
POS me Direct listbox me additem ka coding karte hai to 10 se jyada column column header me nahi ho raha to is problem ka koi solution hai... Agar hai to batayega sir. Example ke tohr par 👇 Item code Item name HSN CODE Qty Rate Gross amt IGST % IGST AMT CGST % CGST AMT SGST % SGST AMT NET AMT
Sir, In notepad opening method if our user form is already open (in my case i have userform with minimized/maximise button) i have minimized my user form and by any chance if someone re-open file by clicking app icon then it shows another userform. So is there any way to stop opening another userform if it is already open or can we resume with already running userform.
Sir, I used Notepad for hide xl workbook and its working very well. But one problem i face that when i open notepad xl workbook show in my Task Manager. If any formula to hide xl workbook from task manager please share.
sir meri ek query hai mujhe ek sheet 2 date ke between ka data filter karna hai with party name se start date A:A column me Hai end Date B:B Column me hai Aur Party Name C:C column me mujhe advanced filter lagana module ke jariye se please help me
thanks for the trick, bbut i have a problem here. I am using ur previous tutorial trick for hidden developer password by clicking on the userform, so now when i enter developer password it doesnt open excel file, how to fix that?
@@vbAFun im using password like password123 and here is the code: Private Sub Image1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) MyPass = InputBox("Enter Developer Password", "Developer Setting") If MyPass = Empty Then GoTo WrongDPass If MyPass = CStr(Sheet3.Range("B4")) Then Application.Visible = True Unload Me Else MsgBox ("Incorrect Password") End If WrongDPass: End Sub
Sir I have best solution for the activation isntead of this code i used online date api method using xml6.0 so if we change system date it won't effect our code so i filled all cells with internet date
Yes you can do, but think if there is no internet then the system not run or he can use the application after expiry with disable the internet connection
@@vbAFun i agree sir without internet connection it won't work but i used to get only demo date and for activation code will use system date because I set period from 365 to 365000 almost life time So what do you think about it is it good idea
Hi Sir, Very sorry for bothering you. I have one more trouble, and the last one, i think. It's about password sharing. For example, a user has a password that he is using, then he gives it to another one. Shortly saying one password for two users. How can we set the vba code in such a way that use have one password for one user. I've tried but not success. Thank you very much.
Instead of comparing current date with last open date, we can post status in setting sheet. At the time of activation status will be active once it gets expired it will change status to expired.
@@vbAFun that's true but once application gets launched on one day later of expiry date, status will get updated to expired. User may not realise n status changes to expired. If he goes back date then also app will not launch as status will hv expired mentioned
Okay means your excel is not micro enable for that goro file select option then select trust centre then there will be button in button and left side click that then click on macro button then click enable all macro enable workbook
Hello sir namaste .. I am from Nepal . Can you please help me with the list box ... I want to make list box show the latest entry after entry .. ... I hope you understood my question ❤❤
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/3EXBOIl
Bahut hi achha tutorial laga Sir, is ke liye dil se dhanywad.
Thank you ❤️
Dear Sir, I am very glad to have completed the project by watching your video and learned a lot. I am from Bangladesh, watching all your videos with great interest and learned a lot, thank you very much. thank you sir.
I appreciate and thank you for your like and share
Thank you sir for very useful information first wala question Maine bhi aapse pucha tha
Welcome and thank you for watching and sharing
Superb sir
Ye kuchh naya hai
Thak you sir
Welcome keep watching and sharing
Oh my God...! Very sensational...?!
Very useful session. Thank you very much for sharing this video.
Welcome and thank you ❤️ your like and share
Thank you very much Sir for your quick answer.
I will apply it to my file, and be back to you for the result.
One more time, thank you.
Thank you ❤️
@@vbAFun waooh! It works very powerfully .
Thank very very much Sir.
Welcome And keep watching
@@vbAFun ok, Sir
Very very nice tutorial sir.
Thank you
Sir I am always all video follow you
Thank you ❤️
Sir I am a senior accountant of various firm I work with tally and other software like Marg and a local software in foxbase made but I can't satisfied and want a complete software with you
Hi, yes it can be created with excel and access but it will take lots of time and trial to do this
Good Work Sir. Tumps Up
Thank you
Thank you sir, coz of your efforts our doubts are cleared. I m waiting for this video since long time. I will work on my project n if any assistance is required I will contact. I learnt from your channel successfully on how to create inventory management system but still I am not getting in right way will do after this video. 🙏🙏
Very soon will upload keep watching and sharing
Sir, Zabardast
Thank you 👍
Good work Sir very well
Thank you
Sir, I am a regular follower of your genuine channel. I am very much thankful for efforts and contribution.Sir, I had a query: How to turn a technical product information to pdf file, the software must have the option to enter its parts number with total parts calculation and allow indication with an arrow through software format and later it can be saved as pdf file as engineering product and parts information sheet. Awaiting for your kind response. Thanks & Regards.
Wow it's great video, But it's very sad that I couldn't join your live class, please so something for me Sir.
No issue you can learn many more by watching the videos
Hello Sir Thanks for such a great knowledge. It was really helpful. I have one query that whenever i run this VBS file from Another Application the User form appears on background and it need to be come in front above all applications. Is there any way by which we can bring this user form above all applications ?
I am trying to do this. Will upload once I find any method
Amazing trick
Thank you ❤️
Sir Mera ek question hai jaise hum application mein activation code laga dete hai aur kisiko trial ke liye application dete hai toh kya hum usse mein kuch cheeze hi access karne de sakte hai baki sabhi disable ho Jaye sirf usse dekhe features but usse access na kar paye aur yeh Sara process access database mein ho sakta hai jo activation code hai woh access database mein generate ho date and all? Agar ho sakta hai toh aap iss per video bana sakte ho?
Y s ye sab ho sakta hai mai ek bade project pe kam kar raha hun apne client ke liye jaise o taiyar hota hai mai share karunga
Ek aur yaad aa gya woh access sirf wo hi kar paye jo trail activation code mein hum usse application mein use karne ki option de aur Jo disable ho woh sirf dekh sake agar uss per woh click kare toh usse message aaye ki iss feature ke access karne ke liye licenced version purchase karna padega woh chahe kisi bhi disabled feature per click kare MSG yeh aaye
Very very thanks sir 🎉
Most welcome
Good evening sir.
Sir we have a instrument whose data file export in CSV format to usb, when this usb connect to pc this data file convert in excel format. My question is that is there any method that we can make a such data file non editable.?
sir thank ap ne 1st question ka answer dia main ne b puchha tha ap se, ItmList update kr di hae, but eik problm pehly se ye b aa ra tha k agr main ne product 6 ko scan kia hae tou wo listbox mein 6 row mein ja ra, agr product 1 ko scan kia tou wo listbox ki 1st row mein ja, Gros amount net payment working but if i scan item 20 then wo item listbox mein nai show ho ga but calculate sahi kary ga...
Aap big fix bale video ke description se file download karke check o sahi work kar raha hai
@@vbAFun sir main wo file download kr chuka hun, which is working 100%, main apko messenger mein video shot send kr chuka hun, time mily tou dekh lejye ga, and im trying to solve tha problm as well...
Sir
Thanks a lot for this useful video...
I have one query...
I in this method, we disabled Micro and then run the program, and its working fine
BUT
I have created Progress Bar and used it in For Loop Function.
After Disabling Micros.. Progress Bar Not working.
Sir Please help to solve this problem.
Almighty Bless You. 😊
Sir hume kisi bhi tareke se exe file install karwa sakte hai bina kisi popup window ke mujhe selenium library install karna hai but Mai chahata hu ki samane wale user ko install hota huya na dekhe
Sir please trial balance se balance sheet bna ni h vba coading se please us pr koi video bnai
Sure, but it is very complicated step to create will try to upload video
Sir apne meri request accept nhi ki, POS ya kisi bhi user form ka data kaise excel table range me enter kr sakte with all feature like ( edit delete search update )
Maine ispe video bana Diya tha apne sayad dekha nahi hai video
Sir delete karne per name list formula file manager se delete ho jata hai sir thank invoice number dene per search hona chahie
Hello sir namaste .. I am from Nepal . Can you please help me with the list box ... I want to make list box show the latest entry after entry .. ... I hope you understood my question ❤❤
Sir background process का
application quit userform code लिखणे के बाद अगर दुबारा excel application मे change karanaa ho to क्या करे
Sir is it possible to run POS application as Mobile app it will be useful to many people. Thank you.
Hi so sorry but VBA has no option to convert VBA to Android
POS me Direct listbox me additem ka coding karte hai to 10 se jyada column column header me nahi ho raha to is problem ka koi solution hai...
Agar hai to batayega sir.
Example ke tohr par 👇
Item code
Item name
HSN CODE
Qty
Rate
Gross amt
IGST %
IGST AMT
CGST %
CGST AMT
SGST %
SGST AMT
NET AMT
10 se jyada column ke liye is video ko dekhe
th-cam.com/video/gHZKToL19TU/w-d-xo.html
Sir, In notepad opening method if our user form is already open (in my case i have userform with minimized/maximise button) i have minimized my user form and by any chance if someone re-open file by clicking app icon then it shows another userform.
So is there any way to stop opening another userform if it is already open or can we resume with already running userform.
Yes this is the problem i am trying to identify and resolved this issue
Sir have you found any solution for this
If yes please tell us
Sir Vba code obfucation for excel project ka application banvo. Thanks
Sure
Sir, I used Notepad for hide xl workbook and its working very well.
But one problem i face that when i open notepad xl workbook show in my Task Manager.
If any formula to hide xl workbook from task manager please share.
Hi that is not possible to hide any app from task managers if that is running in background
Sir notepad me canvert kare ne ke bad save button par click kare to application error msg .aata hai
sir meri ek query hai
mujhe ek sheet 2 date ke between ka data filter karna hai with party name se start date A:A column me Hai end Date B:B Column me hai Aur Party Name C:C column me mujhe advanced filter lagana module ke jariye se
please help me
I have shown theethid for advance filter in many videos. If you want then check otherwise wait will upload a separate video for that
Application.quit what if you have other workbooks open. How can you avoid those being closed or quit as well
Then you can use thisworkboik.close and application.visible = true
How I can add pdf reader in my userform toolbox ? i can't find it out in my toolbox additional controls. Could you please help me ?
You have to installed Acrobat library for that
thanks for the trick, bbut i have a problem here.
I am using ur previous tutorial trick for hidden developer password by clicking on the userform, so now when i enter developer password it doesnt open excel file, how to fix that?
Please check what type of password has been given means if u are given in numeric then convert first textbox no in numeric using val function
@@vbAFun im using password like password123 and here is the code:
Private Sub Image1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
MyPass = InputBox("Enter Developer Password", "Developer Setting")
If MyPass = Empty Then GoTo WrongDPass
If MyPass = CStr(Sheet3.Range("B4")) Then
Application.Visible = True
Unload Me
Else
MsgBox ("Incorrect Password")
End If
WrongDPass:
End Sub
Ye Excel EXE ka Trick Single userform me he, Ye multi userform (Exa...10'15'20 userform )me kise kareka?
Usme bhi ye same kam karega
Sir I have best solution for the activation isntead of this code i used online date api method using xml6.0 so if we change system date it won't effect our code so i filled all cells with internet date
Yes you can do, but think if there is no internet then the system not run or he can use the application after expiry with disable the internet connection
@@vbAFun i agree sir without internet connection it won't work but i used to get only demo date and for activation code will use system date because I set period from 365 to 365000 almost life time
So what do you think about it is it good idea
Sir I have created application exe file but file is using to multiuser.
For multiuser you need to keep data in access
I have not understand but it means use to access database.
sir my pos.vbs file not working tell me the solution plzzzzz
Mne vlookup se bnai h pr data boht h vlookup hang krta h formula
Yes vlookup ek array function hai jisko jyada use karne se file heavy ho jata hai uske liye VBA ka use kare
@@vbAFun ji sir wohi poch rha h ap se kese bnao ap btain
File havy h jati h koi hal btai ap
And thank you so much sir ap ne replay kya 👍😇
Okay will make a video on that
kindly tell me solution if u can, i hope ap bar bar questions ki wja se disturb nai ho rahy hoon gy, agr ho rahy haen tou sorry please ...
please ask if you have any question kyuki aplogo ke question se hi pata chalta hai ki aap kya sikhna ya dekhna pasand karte hai
.vbs file not working... Userform not showing
Hi Sir,
Very sorry for bothering you.
I have one more trouble, and the last one, i think.
It's about password sharing.
For example, a user has a password that he is using, then he gives it to another one.
Shortly saying one password for two users.
How can we set the vba code in such a way that use have one password for one user.
I've tried but not success.
Thank you very much.
I think you want to make single user or multi user right
@@vbAFun Good day Sir.
Yes, i want to make single user.
A password for only one user , and not for two user.
Thank you very much.
Then user registery key with hdd serial no i already created for that
@@vbAFun ok Sir.
Thank you very much.
I will apply it to my file.
And i will let you the result.
Thank you very much Sir
@@vbAFun Hi Sir ,
Thank you very much, it works.
Instead of comparing current date with last open date, we can post status in setting sheet. At the time of activation status will be active once it gets expired it will change status to expired.
Yes it can be done but suppose if the expiry date is 15 feb 2023 but he tried to use in back date from 14 feb then the status will not change
@@vbAFun that's true but once application gets launched on one day later of expiry date, status will get updated to expired. User may not realise n status changes to expired. If he goes back date then also app will not launch as status will hv expired mentioned
Yes once the status has changed then user can not use
I have one query which is can we plot a pivot table in full or with selected fields on userform?
I have created Share market portfolio management using vba with current market price getting updated every minute. Also few technical analysis...
Hi sir
Ap continue item code nahi daloo
Alag alag item code dalki dekho arahahe or nahi
Okay dekhke update karta hun
If you change date to 10-2-2023 and click on demo or activation than in sheet it ll show 16-02-2023 as start date not 10-2-2023
Sir, how to set automatic enable excel file in 2007
I could not understand what you want to enable in excel 2007
Sir, I am to say that,I open my vba excel files at the time first done enable then work in my files. How to solve it.
Okay means your excel is not micro enable for that goro file select option then select trust centre then there will be button in button and left side click that then click on macro button then click enable all macro enable workbook
Ok sir
Ok sir
can u share thise file sir
Why the title is in English, but then the language used is completely different?
Because i speak Hindi very well so that i used auto translated caption
Please help me
What you help required
Hi ajay sir, mine ek request kiya Tha trough Instagram, jub time milega tho please answer dena
Hi, apka koi msg nahi Mila please send again
Hello sir namaste .. I am from Nepal . Can you please help me with the list box ... I want to make list box show the latest entry after entry .. ... I hope you understood my question ❤❤
Will upload soon with master class of listbox pr 2