How to Convert Vba Project to EXE File | Open User form Without Excel | Your Question | Excel Vba

  Рет қаралды 24,811

vbA Fun

vbA Fun

Күн бұрын

Пікірлер: 129
@vbAFun
@vbAFun Жыл бұрын
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3EXBOIl
@md.yeakubali3548
@md.yeakubali3548 Жыл бұрын
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.
@vbAFun
@vbAFun Жыл бұрын
I appreciate and thank you for your like and share
@intakhabkhan9649
@intakhabkhan9649 Жыл бұрын
Bahut hi achha tutorial laga Sir, is ke liye dil se dhanywad.
@vbAFun
@vbAFun Жыл бұрын
Thank you ❤️
@SM-tz1hc
@SM-tz1hc Жыл бұрын
Oh my God...! Very sensational...?!
@venugopal-pn9zt
@venugopal-pn9zt Жыл бұрын
Very useful session. Thank you very much for sharing this video.
@vbAFun
@vbAFun Жыл бұрын
Welcome and thank you ❤️ your like and share
@amituppal
@amituppal Жыл бұрын
Thank you sir for very useful information first wala question Maine bhi aapse pucha tha
@vbAFun
@vbAFun Жыл бұрын
Welcome and thank you for watching and sharing
@falaknazzcreation4083
@falaknazzcreation4083 Жыл бұрын
Superb sir Ye kuchh naya hai Thak you sir
@vbAFun
@vbAFun Жыл бұрын
Welcome keep watching and sharing
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
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.
@vbAFun
@vbAFun Жыл бұрын
Thank you ❤️
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
@@vbAFun waooh! It works very powerfully . Thank very very much Sir.
@vbAFun
@vbAFun Жыл бұрын
Welcome And keep watching
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
@@vbAFun ok, Sir
@sindhuraramya9274
@sindhuraramya9274 Жыл бұрын
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. 🙏🙏
@vbAFun
@vbAFun Жыл бұрын
Very soon will upload keep watching and sharing
@navadgiarun
@navadgiarun Жыл бұрын
Very very nice tutorial sir.
@vbAFun
@vbAFun Жыл бұрын
Thank you
@monirajv
@monirajv Жыл бұрын
Good Work Sir. Tumps Up
@vbAFun
@vbAFun Жыл бұрын
Thank you
@shahidarain9679
@shahidarain9679 Жыл бұрын
Good work Sir very well
@vbAFun
@vbAFun Жыл бұрын
Thank you
@rajbirkeshari5958
@rajbirkeshari5958 Жыл бұрын
Sir I am always all video follow you
@vbAFun
@vbAFun Жыл бұрын
Thank you ❤️
@rajbirkeshari5958
@rajbirkeshari5958 Жыл бұрын
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
@vbAFun
@vbAFun Жыл бұрын
Hi, yes it can be created with excel and access but it will take lots of time and trial to do this
@mealax
@mealax Жыл бұрын
Sir, Zabardast
@vbAFun
@vbAFun Жыл бұрын
Thank you 👍
@muhammadmursaleen7879
@muhammadmursaleen7879 11 ай бұрын
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.?
@kv73477
@kv73477 Жыл бұрын
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 ?
@vbAFun
@vbAFun Жыл бұрын
I am trying to do this. Will upload once I find any method
@aqeelahmad3652
@aqeelahmad3652 Жыл бұрын
Amazing trick
@vbAFun
@vbAFun Жыл бұрын
Thank you ❤️
@channel-ry4xq
@channel-ry4xq Жыл бұрын
Very very thanks sir 🎉
@vbAFun
@vbAFun Жыл бұрын
Most welcome
@shaileshsharma668
@shaileshsharma668 6 ай бұрын
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
@chandrashekharprajapati9451
@chandrashekharprajapati9451 Жыл бұрын
Wow it's great video, But it's very sad that I couldn't join your live class, please so something for me Sir.
@vbAFun
@vbAFun Жыл бұрын
No issue you can learn many more by watching the videos
@MRazzaqYouTube
@MRazzaqYouTube Ай бұрын
Sir delete karne per name list formula file manager se delete ho jata hai sir thank invoice number dene per search hona chahie
@The_Light.gaming
@The_Light.gaming Жыл бұрын
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 ❤❤
@parvezkhot8392
@parvezkhot8392 Жыл бұрын
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. 😊
@rakeshpal500
@rakeshpal500 Жыл бұрын
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.
@starcreation5329
@starcreation5329 Жыл бұрын
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.
@vbAFun
@vbAFun Жыл бұрын
Yes this is the problem i am trying to identify and resolved this issue
@starcreation5329
@starcreation5329 Жыл бұрын
Sir have you found any solution for this If yes please tell us
@fingercross4313
@fingercross4313 Жыл бұрын
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 )
@vbAFun
@vbAFun Жыл бұрын
Maine ispe video bana Diya tha apne sayad dekha nahi hai video
@channel-ry4xq
@channel-ry4xq Жыл бұрын
Sir background process का application quit userform code लिखणे के बाद अगर दुबारा excel application मे change karanaa ho to क्या करे
@amituppal
@amituppal Жыл бұрын
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?
@vbAFun
@vbAFun Жыл бұрын
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
@amituppal
@amituppal Жыл бұрын
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
@suhagchowdhury7525
@suhagchowdhury7525 Жыл бұрын
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.
@vbAFun
@vbAFun Жыл бұрын
Hi that is not possible to hide any app from task managers if that is running in background
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
Sir please trial balance se balance sheet bna ni h vba coading se please us pr koi video bnai
@vbAFun
@vbAFun Жыл бұрын
Sure, but it is very complicated step to create will try to upload video
@shbillingsolutions2860
@shbillingsolutions2860 Жыл бұрын
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 ?
@vbAFun
@vbAFun Жыл бұрын
You have to installed Acrobat library for that
@mohidmalik7374
@mohidmalik7374 Жыл бұрын
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
@vbAFun Жыл бұрын
Aap big fix bale video ke description se file download karke check o sahi work kar raha hai
@mohidmalik7374
@mohidmalik7374 Жыл бұрын
@@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...
@Dan_De_Man
@Dan_De_Man Жыл бұрын
Application.quit what if you have other workbooks open. How can you avoid those being closed or quit as well
@vbAFun
@vbAFun Жыл бұрын
Then you can use thisworkboik.close and application.visible = true
@excelshambhu
@excelshambhu Жыл бұрын
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
@vbAFun
@vbAFun Жыл бұрын
10 se jyada column ke liye is video ko dekhe kzbin.info/www/bejne/nXm9fIelgZZsirc
@manoharchand5093
@manoharchand5093 2 ай бұрын
.vbs file not working... Userform not showing
@arunpatil833
@arunpatil833 Жыл бұрын
Sir I have created application exe file but file is using to multiuser.
@vbAFun
@vbAFun Жыл бұрын
For multiuser you need to keep data in access
@arunpatil833
@arunpatil833 Жыл бұрын
I have not understand but it means use to access database.
@sportsbook4059
@sportsbook4059 Жыл бұрын
sir my pos.vbs file not working tell me the solution plzzzzz
@kmtechs
@kmtechs Жыл бұрын
Ye Excel EXE ka Trick Single userform me he, Ye multi userform (Exa...10'15'20 userform )me kise kareka?
@vbAFun
@vbAFun Жыл бұрын
Usme bhi ye same kam karega
@channel-ry4xq
@channel-ry4xq Жыл бұрын
Sir notepad me canvert kare ne ke bad save button par click kare to application error msg .aata hai
@hemantjshah
@hemantjshah Жыл бұрын
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
@vbAFun Жыл бұрын
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
@hemantjshah
@hemantjshah Жыл бұрын
@@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
@vbAFun
@vbAFun Жыл бұрын
Yes once the status has changed then user can not use
@hemantjshah
@hemantjshah Жыл бұрын
I have one query which is can we plot a pivot table in full or with selected fields on userform?
@hemantjshah
@hemantjshah Жыл бұрын
I have created Share market portfolio management using vba with current market price getting updated every minute. Also few technical analysis...
@kailashsoni676
@kailashsoni676 Жыл бұрын
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
@vbAFun
@vbAFun Жыл бұрын
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
@kailashsoni676
@kailashsoni676 Жыл бұрын
@@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
@aiyazlakhani
@aiyazlakhani Жыл бұрын
Sir Vba code obfucation for excel project ka application banvo. Thanks
@vbAFun
@vbAFun Жыл бұрын
Sure
@joshitoshi9835
@joshitoshi9835 Жыл бұрын
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
@vbAFun Жыл бұрын
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
@joshitoshi9835
@joshitoshi9835 Жыл бұрын
@@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
@dolphinfoodsbeverages4555
@dolphinfoodsbeverages4555 Жыл бұрын
Sir is it possible to run POS application as Mobile app it will be useful to many people. Thank you.
@vbAFun
@vbAFun Жыл бұрын
Hi so sorry but VBA has no option to convert VBA to Android
@shanpalia
@shanpalia Жыл бұрын
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
@vbAFun
@vbAFun Жыл бұрын
I have shown theethid for advance filter in many videos. If you want then check otherwise wait will upload a separate video for that
@kailashsoni676
@kailashsoni676 Жыл бұрын
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
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
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.
@vbAFun
@vbAFun Жыл бұрын
I think you want to make single user or multi user right
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
@@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.
@vbAFun
@vbAFun Жыл бұрын
Then user registery key with hdd serial no i already created for that
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
@@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
@claudegbessena5069
@claudegbessena5069 Жыл бұрын
@@vbAFun Hi Sir , Thank you very much, it works.
@mohidmalik7374
@mohidmalik7374 Жыл бұрын
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 ...
@vbAFun
@vbAFun Жыл бұрын
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
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
Mne vlookup se bnai h pr data boht h vlookup hang krta h formula
@vbAFun
@vbAFun Жыл бұрын
Yes vlookup ek array function hai jisko jyada use karne se file heavy ho jata hai uske liye VBA ka use kare
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
@@vbAFun ji sir wohi poch rha h ap se kese bnao ap btain
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
File havy h jati h koi hal btai ap
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
And thank you so much sir ap ne replay kya 👍😇
@vbAFun
@vbAFun Жыл бұрын
Okay will make a video on that
@vishwanathpadvi1980
@vishwanathpadvi1980 15 күн бұрын
Muze ek software banake chahiye he
@pradeepbeherag.3418
@pradeepbeherag.3418 Жыл бұрын
Sir, how to set automatic enable excel file in 2007
@vbAFun
@vbAFun Жыл бұрын
I could not understand what you want to enable in excel 2007
@pradeepbeherag.3418
@pradeepbeherag.3418 Жыл бұрын
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.
@vbAFun
@vbAFun Жыл бұрын
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
@pradeepbeherag.3418
@pradeepbeherag.3418 Жыл бұрын
Ok sir
@pradeepbeherag.3418
@pradeepbeherag.3418 Жыл бұрын
Ok sir
@Gandaki_News
@Gandaki_News Жыл бұрын
can u share thise file sir
@darsalalahtrading8691
@darsalalahtrading8691 Жыл бұрын
Hi sir Ap continue item code nahi daloo Alag alag item code dalki dekho arahahe or nahi
@vbAFun
@vbAFun Жыл бұрын
Okay dekhke update karta hun
@cristhianjfonseca2890
@cristhianjfonseca2890 Жыл бұрын
Why the title is in English, but then the language used is completely different?
@vbAFun
@vbAFun Жыл бұрын
Because i speak Hindi very well so that i used auto translated caption
@pradeepbeherag.3418
@pradeepbeherag.3418 Жыл бұрын
Please help me
@vbAFun
@vbAFun Жыл бұрын
What you help required
@aslamkoodathil7934
@aslamkoodathil7934 Жыл бұрын
Hi ajay sir, mine ek request kiya Tha trough Instagram, jub time milega tho please answer dena
@vbAFun
@vbAFun Жыл бұрын
Hi, apka koi msg nahi Mila please send again
@The_Light.gaming
@The_Light.gaming Жыл бұрын
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 ❤❤
@vbAFun
@vbAFun Жыл бұрын
Will upload soon with master class of listbox pr 2
Какой я клей? | CLEX #shorts
0:59
CLEX
Рет қаралды 1,9 МЛН
How To Create A MultiUser Login Form In Excel VBA || Part 1
19:42
How to Add Minimise and Maximize button In Excel Userform
5:51
Excel Vba Tutorial - Convert an Excel File to an "exe" Executable Program
15:53
VBA User Form: Add, Update, Delete and Save
22:47
hay kel
Рет қаралды 70 М.
Excel VBA Calculations in a Userform
14:43
Online Pc Learning
Рет қаралды 106 М.
Fully Automated Data Entry User Form in Excel | No VBA
29:22
PowerEx by Jitendra
Рет қаралды 317 М.