Sir, thanks a lot for again unique video uploading for us. is video ke coding se mujhe bahut sari chhoti chhoti chij sikhne ko mili. Sir mujhe aisa laga ki activation userform ka close(X) button disable hona chahiye, kiyun ki bina activation code daale aur bina demo button click kiye close button ko click karne se file open ho ja rahi hai saath hi same file alag alag computer men open bhi ho rahi hai.
Haan aisa hona chahiye but ye video maine practice ke liye banaya hai to aplog ise banyoye aur practice kare aur close button ko kaise disable karna hai spe bhi maine video bana rakhe. Thank you for your support, like and comment. Keep watching
Thank you very much brother, it will really help me, also make one video for Excel convert to Exe and all excel function hide option so that nobody will know how program was made thank you so much for this wonderful video i join your membership but i have one request, if any time i miss the live zoom session then pls provide the recording of the session
Thanks a lot, Boss. From today onwards, I could sleep well without any issues. Life is entirely different when people like u r around with a sharing mind. God bless you.
And i think in other computer install it ll over write the harddrive serial number of other computer hard drive automatically as it is in code update to sheet from hard drive thank you again for wonderful vedio
Interesting tricks and very educative stuff. Thanks a lot. My problem is I do not understand the language but I like your methods of coding. Thanks for sharing your ideas.
Hi sir thanks for the vedio its great but i think it can open in other computer as you say 27:14 to 27:20 min again actform will open. So if put same activation code it can open in other systems as hard drive serial number copy automatically to sheet. Because you mention if not equal to same hard drive number again open actform please advice if i am not correct thank you
And in hard drive serial number it already serial number not match then we can exit the form and worksheet so cant install in other computer at all thanks for reply appreciated a loy
Sir, aapka ye bhi video bahut hi solid laga. Aapke video dekh ke mai ek practice project bana raha hu, jab bhi muze problem aata hai, to mai aapke video dekh leta hu... Sir mai chata hu aap agala video nevigation menu with RGB command ke saath banay wo bhi loop chalake. Thank u sir.
Hi Sir Project is Awesome One Suggestion sir Jab Customer ka 1 year ka subscription katam hone wala hai tho unko 1 month pehele Notification dena chahiye O Notification Userform ke upar display ho raha hai tho acha hai ki apka software expiry hone mei itna din baaki hai bolke
Great sir, thank you very much for yet another video. 1 query sir, if I change the system date then the software starts working again.. please help on this sir
Sir, me Military se hu, or sir me chahta hu ki me apne sare soldier's ko pay slip unke mail par bhejna chahta hu....to vba keise banaye pay slip bhejne ke liye...plz is bare me bataiye
Hello Sir ! I like your videos and the way of describing the project. sir i would like to ask about the search query i.e All, Emp ID , Date etc. Basically i am working on Computer workshop Maintenance project.. kindly guide me. Thanks.
Excellent work sir Sir is that possible to enter my data through mobile (android) and it will display in my Excel VBA application??????? If yes then please guide me
Sir mery pass 1 idea hy jis k zarye hamy khod install karna nahe hoga Os say ye hoga k ham ye software internet py dain gy log waha say khod download kary ga our per activation k lye call kary ga Our jo S.NO hy wo khod daily change hota jaye ga.
Sir jaha S.NO lika hota hy waha hum =TODAY()*4 liky to S.NO date k sat automatic change hota jaye ga Ager kisi ny soba contact kia to hm onko zyada time dyngy Ager kisi ny sham ko contact kia to osko hm kam time dyngy K " baye S.NO itny time bad expire hojaye ga please software ko is time k ander ander active karo " Dosra method ye hy k hum osy time k sat adjust kary =Now()+6 Ye pir har 6 hours bad update hojaye ga
@@vbAFun sir mujhe koyi small project ka work dijiye Without any cost . Hume 2 saal se excel vba practice kortahu. Mujhe real project ka knowledge kaam hai.
Maine already bahut sare small project bana ke uska video banaye huye hai. Agar aap really concept aur method ko janna chahte ho to aap video ko dekhe aur usi tarah se dusre project ke bare me soche fir isi method ko laga ke banane ka koshis kijiye
What if i created macro enabled data entry form in excel sheet but not in user form . how to use code instead of form.show after activation key criteria if my user form is in sheet 1 ( that is excel object ) ? thanks in advance
Hello Sir, thank you very much for the excel vba videos. please I have a concern about the expiration date . It is that the user can at any time deregulate the system date, from his Pc to his advantage. Please in this case, how do we do it? Thank you very much
@@vbAFun Thank you very much for answering me. I will make myself clear to understand. For instance, if the file will expire in 5 days, and the system date is for example 10/02/2023; if he changes the system date to 05/02/2023, the expiration date will not be 5 days but 10 days, this is the issue. Thank you Sir.
@@vbAFun please Sir, in this case, it will not profitable for the owner of the file but for the user, because intead the file expires in 5 days, it will expire in 10 days. How can set the code vba in such a way that if the user changes the system date, it will not have impact on the expiration date.
@@vbAFun sir is ke lye aik register banana hota hay aur is rgister may 1st nmbr pe addmision fee likhna hota hay aur baad jan se le kar dec tak har mahene ka monthly fee hota hay ...jab koi bacha fee submitt karta hay tu wo bhe wazeh hona chahye aur pending hay wo be.. Jo bacha fee submit kary to sat may is ka reccipt auto ajaye..to behtar hoga
Sir agar excel ko open nhi karna hai or multi userform ho tab kese hoga If koi activation wale x se exit kre to pura application close ho jaye or wapas se start ho
Sir agar 1year complete ho gya phir uske baad hum isko kese activate karenge Agar kisi ko database bana kar diya ho to Wo file to open nhi hoga jo other person ko diya Us condition me user ka data kese acess hoga plz reply
Sir, Please tell me how to copy 1. Selected sheets from one workbook to another workbook through excel vba code 2. How to copy vba codes of a workbook to another workbook through writing a vba code. Pls. Solve my problem at the earliest.
Code is not working Sir. When I was running this code in MSO 2007 it's only show the user form and nothing else did. Only show user form. Command button did nothing. Why Sir?
Simple jab bhi aap kisi ko software de to sheet me serial no change kar de Ya aap apne ek developer password create kare jisse entry karne ke bad dusre system ke liye dusra sl no de sakte hai
Good Evening Sir, In This video You have used the following code to extend one year but how can it work. Always it checks the system date and adds 365 days to the current date CODE: Sheet1.Range("B5") = Date + 365
As you see the video that when you enter the activation code which is not enable, so again we repeat the same activation code for activation with developer password. We need some add some more code for this process.
Thank you so mutch sir. VBA Fun is Great great.....
From Nepal
Sir, thanks a lot for again unique video uploading for us. is video ke coding se mujhe bahut sari chhoti chhoti chij sikhne ko mili. Sir mujhe aisa laga ki activation userform ka close(X) button disable hona chahiye, kiyun ki bina activation code daale aur bina demo button click kiye close button ko click karne se file open ho ja rahi hai saath hi same file alag alag computer men open bhi ho rahi hai.
Haan aisa hona chahiye but ye video maine practice ke liye banaya hai to aplog ise banyoye aur practice kare aur close button ko kaise disable karna hai spe bhi maine video bana rakhe. Thank you for your support, like and comment. Keep watching
I think close button should be enable for such type software
Bcoz we close the entire application with close button so anyone can not open your code.
Yes I have lots of video has uploaded for your query you can edit and use aa per your required
Thank you sir, I don't know hindi very well, but your teaching and explain method very good. Thanks once again. This video very useful
Thank you for your support, from the next video I will try to make in English language please keep watching and sharing
Ek sal bad firse ohi activation code dalte hai to fir ek sal ke liye active ho raha hai .. thank you sir
Yes, kyuki o demo tha
It was a project I was looking for but couldn't find. Thank you so much. good luck with your effort (From Turkey)
I appreciate, thank you for your like, share and comment
Very informative session. I was able to learn a lot of things .Thank you very much for this wonderful video.
I appreciate
Thnak You So much Sir..... U did this better than my expectation.... Thanks A lot..
Thank you, please keep watching to learn more tricks
Very very.What I was expecting become true.Thank you Sir
Hi Sir , ur all videos are excellent,
Thank you very much for your support and like this videos
Excellent thinking and systematic approach was followed in each of your videos..
Sir,
I LIKE ''VBA Fun'' 👍💖
Your content is very informative , I Learnt alot from your vedios.
Numan frm Pakistan.
I appreciate, Thank you for you like and share, it helps us
Sir You are legend, I am your big fan sir
Thank you❤
Very nice trick
Great work sirji
Good video keep up
Many thanks for such videos
Thank you, for encourage
@@vbAFun
Can you make the same thing which ask for activation online only and you have the right to give one time activation key
This can be done. But I have to research
@@vbAFun Thanks for your response
Thank you very much brother, it will really help me,
also make one video for Excel convert to Exe and all excel function hide option so that nobody will know how program was made
thank you so much for this wonderful video
i join your membership but i have one request, if any time i miss the live zoom session then pls provide the recording of the session
I appreciate, thank you very much for you support. Yes sure will let you know
Sir, I really appreciate for your efforts to making us to learn new ideas in VBA
Thanking You Very much and Keep it up...........
Dhanyabad
Thanks a lot, Boss. From today onwards, I could sleep well without any issues. Life is entirely different when people like u r around with a sharing mind.
God bless you.
I really appreciate, thank you very much for watching this video and such motivational comment.
@@vbAFun Thank you sir. Sir, aap ka school logo ki file hame send karenge.
And i think in other computer install it ll over write the harddrive serial number of other computer hard drive automatically as it is in code update to sheet from hard drive thank you again for wonderful vedio
Really amazing sir
VERY NICE SIR
Interesting tricks and very educative stuff. Thanks a lot. My problem is I do not understand the language but I like your methods of coding. Thanks for sharing your ideas.
I appreciate and thank you for your comments.
Congratulations and thank your for such a nice video with a simple explanation to understand like your other video also.
Thank you
Thank you sir for your videos.
Welcome
Hi sir thanks for the vedio its great but i think it can open in other computer as you say 27:14 to 27:20 min again actform will open. So if put same activation code it can open in other systems as hard drive serial number copy automatically to sheet. Because you mention if not equal to same hard drive number again open actform please advice if i am not correct thank you
Yes, maine kaha tha but aap kisi ko activation code kyu Dena sath me ye ek method and concepts maine bataya hai
Ya its one way to solve the problem and i think even we give code
And in hard drive serial number it already serial number not match then we can exit the form and worksheet so cant install in other computer at all thanks for reply appreciated a loy
Sir, aapka ye bhi video bahut hi solid laga. Aapke video dekh ke mai ek practice project bana raha hu, jab bhi muze problem aata hai, to mai aapke video dekh leta hu...
Sir mai chata hu aap agala video nevigation menu with RGB command ke saath banay wo bhi loop chalake.
Thank u sir.
Thank you
Brother if you are developing any project then it is advisable to you that, you should join the membership of the channel
Sir, maine bhi join kiya....👍
Thank you in next Sunday you can join our online session
@@satishmandlik9724 bahut acha kiya, bhai koi bhi mehnat kar raha hai to usko bhi acha lagna chahiye, ki uski mehnat ki koi kadr kar raha hai
Excellent. I ❤️ your teaching process.
Thank you🌹
Hi sir
From Oman
Thanks
Hi Sir
Project is Awesome
One Suggestion sir
Jab Customer ka 1 year ka subscription katam hone wala hai tho unko 1 month pehele Notification dena chahiye
O Notification Userform ke upar display ho raha hai tho acha hai ki apka software expiry hone mei itna din baaki hai bolke
Thanks Sirji..itS greaT....Thank You
Thank you please keep watching.
Important..! Thanks so lot
Sir High Protection par ek video zaror banain please..
Sure
Good Ajay. G
Thank you
Sir. Agar HDD nahi hai mere laptop me ssd. Hai. To kya likhege
Same code hdd or sdd are same for coding
@@vbAFun thanks sir
Today, Sir, incredible work has been done
It's been a long time coming and nobody's been up to it yet
Thank you
Excellent sir
Thank you
Great sir, thank you very much for yet another video.
1 query sir, if I change the system date then the software starts working again.. please help on this sir
Great Sir ♥
Thank you please keep watching
Sir please make a Inventory management software like purchase, sales, stock report, profit and lose. With GST invoice. Thank you
dear sir when you start hospital manegment software
Thank you Very much for your suggestions. This is in my list will create. Thank you for your like, share and comment
Thank you so much sir
Welcome
Do you work payment per project.
Excellent video really liked it. Can you make the video for the security method without the password? Thanks
Sure will create a separate video to secure vba password
Sir, me Military se hu, or sir me chahta hu ki me apne sare soldier's ko pay slip unke mail par bhejna chahta hu....to vba keise banaye pay slip bhejne ke liye...plz is bare me bataiye
HI SIR KYA YE DATA ACCESS SE CONNECT KARKE USE HO SAKTA HAI
Yes
PERFECT
Thank you
Aap Muzaffarpur se ho kya
Haan, mai muzaffarpur se hi hun
Main v Muzaffarpur se hoon classes kha hai Muzaffarpur me
Marwan, rewa road
Hello Sir ! I like your videos and the way of describing the project. sir i would like to ask about the search query i.e All, Emp ID , Date etc. Basically i am working on Computer workshop Maintenance project.. kindly guide me. Thanks.
Hi you can watch this video for multiple criterai search
th-cam.com/video/Cq-m98mNoTs/w-d-xo.html
Excellence. Sir when it expire enter same activation code it work. How to make only for 1yrs when expire clear excel start date and end only work.
I have given a demo video that is not hy you used the same activation for future date
Excellent work sir
Sir is that possible to enter my data through mobile (android) and it will display in my Excel VBA application???????
If yes then please guide me
I have note done aisa abhi dekhte hai kusch idea aata hai to banane ka koshish karunga
Sir school mangmant system software banaya
Sure
Can you share some forms of school like admission form receipt form and other form which use in school
G Yes
Please share on mail
Sir mery pass 1 idea hy jis k zarye hamy khod install karna nahe hoga
Os say ye hoga k ham ye software internet py dain gy log waha say khod download kary ga our per activation k lye call kary ga
Our jo S.NO hy wo khod daily change hota jaye ga.
Idea is good
Sir jaha S.NO lika hota hy waha hum
=TODAY()*4 liky to S.NO date k sat automatic change hota jaye ga
Ager kisi ny soba contact kia to hm onko zyada time dyngy
Ager kisi ny sham ko contact kia to osko hm kam time dyngy
K " baye S.NO itny time bad expire hojaye ga please software ko is time k ander ander active karo "
Dosra method ye hy k hum osy time k sat adjust kary
=Now()+6
Ye pir har 6 hours bad update hojaye ga
Kya is type ka software sell hota hai??
Yes is tarah se software bana ke sale kar sakte hai but small level organisation ya company ko.
@@vbAFun sir mujhe koyi small project ka work dijiye Without any cost . Hume 2 saal se excel vba practice kortahu. Mujhe real project ka knowledge kaam hai.
Maine already bahut sare small project bana ke uska video banaye huye hai. Agar aap really concept aur method ko janna chahte ho to aap video ko dekhe aur usi tarah se dusre project ke bare me soche fir isi method ko laga ke banane ka koshis kijiye
What if i created macro enabled data entry form in excel sheet but not in user form . how to use code instead of form.show after activation key criteria if my user form is in sheet 1 ( that is excel object ) ? thanks in advance
I think there is one method to create but i have to try first then i can let you know
@@vbAFun thank you
Hello Sir, thank you very much for the excel vba videos. please I have a concern about the expiration date .
It is that the user can at any time deregulate the system date, from his Pc to his advantage.
Please in this case, how do we do it?
Thank you very much
Yes if he changed the system date then he can continue
@@vbAFun Thank you very much for answering me.
I will make myself clear to understand.
For instance, if the file will expire in 5 days, and the system date is for example 10/02/2023; if he changes the system date to 05/02/2023, the expiration date will not be 5 days but 10 days, this is the issue.
Thank you Sir.
Yes, you understand clearly
@@vbAFun please Sir, in this case, it will not profitable for the owner of the file but for the user, because intead the file expires in 5 days, it will expire in 10 days.
How can set the code vba in such a way that if the user changes the system date, it will not have impact on the expiration date.
No issue I will explain how to make profitable application
Sir app k channel ki member ship kasay milay gi
Channel pe jane ke bad apko join button milega uspe click karke join karna hai
Hi sir plz Account manager kilye aik software bana de plz
Account manager me kya kya information dena chahiye
@@vbAFun sir is ke lye aik register banana hota hay aur is rgister may 1st nmbr pe addmision fee likhna hota hay aur baad jan se le kar dec tak har mahene ka monthly fee hota hay ...jab koi bacha fee submitt karta hay tu wo bhe wazeh hona chahye aur pending hay wo be..
Jo bacha fee submit kary to sat may is ka reccipt auto ajaye..to behtar hoga
Is alawa kal may apko wo fee register hay na uska pic bhej tu shayed ap behtar tariqe se samajh sake.
Sure
@@vbAFun sir wo pic kis tarah bhejo
Sir agar excel ko open nhi karna hai or multi userform ho tab kese hoga
If koi activation wale x se exit kre to pura application close ho jaye or wapas se start ho
Software installed ofter icon show and icon shartcut show desktop dubleclik from show
Okay will check how this can done
Thanks
Welcome
SIR
AGAR USER OPEN KARNESE PAHLE COPY BANA LETA HAI TO
EK HI CODE DUSRE COMPUTER ME BHI CHALEGA
HA YA NA ?
Haan tab ye chalega but activation code. Chaiye hoga .
Sir agar 1year complete ho gya phir uske baad hum isko kese activate karenge
Agar kisi ko database bana kar diya ho to
Wo file to open nhi hoga jo other person ko diya
Us condition me user ka data kese acess hoga plz reply
Ye ek demo file hai agar isko renewal jaise banana hai to apko alag ek module banana hoga jisse ki iske file ko dubara se activate Kiya jaye
@@vbAFun module me kya likhna hoga sirji
Sir,
Please tell me how to copy
1. Selected sheets from one workbook to another workbook through excel vba code
2. How to copy vba codes of a workbook to another workbook through writing a vba code.
Pls. Solve my problem at the earliest.
Sir activation expire hone se 8 din before reminder message aana chahiye ye code kaise likhe? Please guide me.
Sir, how to convert excel file to exe file, please tell me easy software ( window 2007)
सर अगर demo मे सभी बटन यूज करने दिया जाए
और उसके बाद एक्सपायरी पर सभी बटन लॉक करना हो तो क्या चेंजेज करना होगा
Expiry pe kusch nahi khulega only registration ke liye userform open hoga
@@vbAFun ok thanks demo button pe click karne baad bhi activation form dikha raha hai
Kya unload me command insert Karu taki 7 din hi show ho
Good 🙂🙂 sir ji
I sent you a mail
Waiting your response
Hi sir, how can i get your membership?
How can i contact you?
Hi dear you can join our channel using join button
Code is not working Sir. When I was running this code in MSO 2007 it's only show the user form and nothing else did. Only show user form. Command button did nothing. Why Sir?
It should not happen please share on Instagram or join membership program for live support
Isne sabke like ek hi activation code hum sabh ke liye alag alag kaise banaye
Simple jab bhi aap kisi ko software de to sheet me serial no change kar de
Ya aap apne ek developer password create kare jisse entry karne ke bad dusre system ke liye dusra sl no de sakte hai
If I click on X button on userform it will unload and I can access the workbook without license.
This is just for tutorial I have explain already how to disable cross button
Please give me access to your download file,, it's not runable
File given in description
Sir code is not working in my pc. It shows some error 429 I think. And also my HD number shows empty. Give me proper solution Sir.
Please share screen shot of error on my Instagram with debug
ok Sir
👍👍👍👍👍
Good Evening Sir,
In This video You have used the following code to extend one year but how can it work. Always it checks the system date and adds 365 days to the current date
CODE:
Sheet1.Range("B5") = Date + 365
Yes, it will work with system date,
hello sir agar hum demo pe click kar ke use karte hain toh har bar activation form open ho ja raha hai..... please fix it
Please watch the and use the code
After 1 year how can we provide a new activation code ? and how this will work ?
As you see the video that when you enter the activation code which is not enable, so again we repeat the same activation code for activation with developer password. We need some add some more code for this process.
Sir, Please upload videos for changing activation code once expired.
Sir activation HDD number nhi show ho raha
Video ko complete dekh ke usi ke anusar file ko process kare
Sar ap vba Fun nehi ho apto VBA Ka MBBS ho
Thank you for your comment
To fast in explanation
Yes, i agree, you can just reduce the play speed to watch carefully
You don’t do that we can only entry 1,2,30 in demo
Sorry I could not understand
Thank you so mutch sir.
Welcome
@@vbAFun sie please create a instilation file for excel vba
Thank you but basically there is no option to create installation file from excel vba you have to use a third party application for executable file