Sir please develope School managment system with monthly fee collection.
@kofimaracktv
Жыл бұрын
Hello i have designed the frontend but the validation is not working
@kofimaracktv
Жыл бұрын
Please help me
@CristianGonzalez-ly8nu
5 ай бұрын
Hi Dilip, congrats working fine but I run through Linux and surprised that works but the login it's optional, I mean you can closing window or enter credentials, Do you know that? 🤯 In that case if you open a workbook in Linux you avoid this security. I hope you can answer me.thanks alot
@sallytong241
2 жыл бұрын
Dear Sir, Thank you for your video. I have one tiny question about opening the form. I have encountered a problem before the login form show up. The application shows up first in just one second then the login form. Is it possible not to show the entire application before the login form show up?
@abhay6276
3 жыл бұрын
Why do we need to creat login page or data entry if there is Google form...anyone can tell me.? In the Google form we can easily collecte data and it user-friendly too..
@dywaneturner7030
2 жыл бұрын
I Follow you code to the letter, and I got LOCK OUT OF MY FILE, THANKS!
@Deepak_Singh1008
4 жыл бұрын
Hello would appreciate you if you make a small video on Excel VBA iif function.
@muychamnan9993
4 жыл бұрын
Please sharing how to disable the control box (x) on the upper right side of the user form.
@michaelsvenson2456
Жыл бұрын
There where some problems with the code so now I can´t open my file, even with the password, any way around it ?? 🙂
@EchoVibeagain
Жыл бұрын
After successfully done this job....the excel file did not close .what should I do
@hakimj3995
5 ай бұрын
Hi Dilip, thanks for your useful & clear explanations. May you kindly forward the codes regarding the following: NEED TO CAPTURE THE USER ID FROM THE LOGIN FORM TO AUTOMATICALLY INPUT IT INTO A DATA ENTRY FORM. Thanks,,,
@edoundema4426
Жыл бұрын
good morning pleas how did you link that user form with your table
@franklinbabuparaiayyar6494
3 жыл бұрын
Hi! Dilip! This is an excellent tutorial. It's very much useful.greetngd to you. Superb 👍👏👏👏👌😎 & Also some doubts are there. Can I ask you? Dilip
@deepakgautam8958
2 жыл бұрын
I emailed but did not get any response for a month still waiting. I did one Data Entry register but have just minor issue I could not able to save file when I click on save click button. Still fighting for it🙁 really want to save the entry made but all click button work except save button😒😒
@SimplifiedTuts
2 жыл бұрын
Does is possible to verify login credentials by online server database.
@auwalamshi8980
Жыл бұрын
Hello, I followed the code but I locked myself out, and the system is not recognizing/accepting the password.
@auwalamshi8980
Жыл бұрын
What should I do now
@martin_explore
4 жыл бұрын
Nice, please add code if userform is open, then the worksheet is hidden, thanks
@yopiyuandani8710
4 жыл бұрын
Hi, thx for this tutorial, pls develop document control system for oil & migas Project or construction Project
@thedatalabs
4 жыл бұрын
Please share the requirements with us. You can find the contact details in description box. Thanks!
@JanusTheRealDeal
8 ай бұрын
Nice and useful video! However, what if I need to password protect only some fields of a userform (like an ID for instance), to prevent unauthorised editing of sensible data?
@devendardev9497
3 жыл бұрын
Sir I'm getting Run-time error '424': Object required This is showing under WORKBOOK
@ajuvycostawailia3980
Ай бұрын
Hi sir how if we forgot password and can't open anymore..how to solve it...
@thedatalabs
Ай бұрын
You can open the Excel file without enabling macro and then unhide the worksheet to know the forgotten key.
@Chikulibradoo
Жыл бұрын
We wanted to create a multiple access app with use how can do ?
@sudiptamondal6424
2 жыл бұрын
how to setup restrict access using pc ip address or pc user name
@robertspidey8136
2 ай бұрын
❤❤
@cheknauss9867
2 жыл бұрын
The username and password is: "admin" for username, and "admin" for password. Without this, the video and file are about as helpful as a slap in the face with a slimy fish tail.
@kaustavnath8898
3 жыл бұрын
But how do i control Log In Ids.... I may have 10 Data Entry Operators then How do I control the access.
@laxmanp3156
6 ай бұрын
💌
@astonduncan1263
3 жыл бұрын
It worked! thank you
@dywaneturner7030
2 жыл бұрын
The Focus Mode, would not Release
@saujanyasubedi5302
2 жыл бұрын
If user cross the login form, the sheet will automatically get opened despite of seeking password. Please suggest how to solve this issue
@caianevans7853
2 жыл бұрын
I put the password and user in and click the button but nothing happens?
@durgeshmishra3986
4 жыл бұрын
Thanks Mr Dileep, Finally i have done, Thanks a lot
@durgeshmishra3986
4 жыл бұрын
Can i give read only access too?
@sanjeevkawan1668
4 жыл бұрын
Nice vedio....Thanks for the coding .... keep going
@terabergconsultants9697
2 жыл бұрын
Hi, incase if i want login for each sheet, is that possible ?? could you share the codes pls...
@landgegaile6957
3 жыл бұрын
thank you very much it helps me a lot. that was awesome.
@Khunryijduy
Жыл бұрын
Popcom 🎉❤❤❤❤❤❤❤❤🎉😊❤😊😊😊🎉😂😂😂🎉
@abdul-latifahmed3215
3 жыл бұрын
Not working for me. Getting error. Maybe, I have to try more. Thanks anyway for the tutorial video.
@tarunsamanta9919
2 жыл бұрын
How to link this username to the database excel sheet submitted by column
@akhilsoman8167
3 жыл бұрын
Hi The DataLabs, Thanks a lot for this tutorial and effort. As always, very useful. I used this to create a login page for the user form I made based on your previous videos. As you mentioned in the end of the video, the login page fires up only when the user clicks the "enable macro" message in excel. But before macro is enabled, although the Data entry form icon in the sheet 1 is not usable, the user can easily open the Database in the 2nd sheet and make changes in the entries. Is there a way to allow access to both Data entry form sheet (Sheet 1) and the Database (Sheet 2) sheet only after the user enters the correct credentials? If yes, what changes in the code (and where? e.g, user form, worksheet, module coding page) should it be done? It will be really helpful if you could provide a response. Thanks
@paolo-jaycamaing7714
3 жыл бұрын
Does it work when the Excel file is uploaded and shared in Google Drive?
@ssedits4338
Жыл бұрын
Hi sir you add module 1 code but we can't see the full code pls tell the solution
@robertspidey8136
2 ай бұрын
Very helpful. Thanks brother ❤
@aryankumar9784
4 жыл бұрын
Can you please tell me if we want to track time of login and logout but it should be added in login button... Please help..😔😔
@SIFAT.MOLLAH
2 жыл бұрын
Abal
@ibrahimmuhammad9509
4 жыл бұрын
nice
@Chikulibradoo
Жыл бұрын
Hello
@dema-3000
4 жыл бұрын
When I open the excel file, Excel is asking me to Enable Contect (same like on the video). But if I don't enable it, then I can do everything and no need to login. If I login, then I don't see the sheets... ?!?
@mallikarjunakambham7346
3 жыл бұрын
Login instance is not working... can you please explain it again.
@สองล้อคู่ใจ-ฝ5ม
2 жыл бұрын
I have multiple users. How do I add them?
@alcon3053
3 жыл бұрын
I have a Developer tab, but no icons in it are available, how can I make them available to use it?
@dustyarcher
Жыл бұрын
Thank you buddy very useful 💕 it!
@NR-mh9zj
4 жыл бұрын
Wonderful👌keep continue ur service👍
@thedatalabs
4 жыл бұрын
Thanks!
@alessioframba1023
4 жыл бұрын
First of all, nice video; secondly, I have a question. I have userform in excel which asks user to enter user id and password. I want a to have "Remember Me" check button on my userform which will remember user details and he wouldn't have to enter user id and password again and again. Can please provide me with an example code. Thanks
@Thecomputerguide
3 жыл бұрын
can i make EXCEL LOGIN FORM USING VBA in excel file, in which i already done some VBA codes before.
@thedatalabs
3 жыл бұрын
Sure, you can add it in existing project as well. Thanks!
@Thecomputerguide
3 жыл бұрын
@@thedatalabs but how I can add... Means I have created a STUDENT REGISTERATION FORM using VBA now my requirements is that excel sheet open after login access.
@RASHiDALi143
2 жыл бұрын
Thanks Very Good tutorial,
@garyhorne1134
2 жыл бұрын
This is great thanks. Is there a way of seeing who has logged in to view the worksheet. Thanks
@douwefennema2437
3 жыл бұрын
Thank you for sharing. It is very interesting to find out this possibility. Is it possible to create a login connected to a powerpoint presentation where students login, read the pages and before exiting the powerpoint it saves where they left, so that the next time they login it will continue from the last page? I make very long powerpoint... sometimes up to 120 pages. Kind regards, Douwe
@joven82
4 жыл бұрын
Tnx sir!
@mumbapatrick8958
4 жыл бұрын
These tutorials are splendid and they have helped me big time. Thumbs up to all of you.
@vishalhegade1690
3 жыл бұрын
Need computer service center excel sheet
@MohamedAboAbdo03
11 ай бұрын
Thank you so much Sir
@melusikeith4886
3 жыл бұрын
why is it when l save my project when l am done coding and l close excel, when l open it again its just blank, no login or whatsoever
@thedatalabs
3 жыл бұрын
Please save this file with macro enabled extension (.XLSM) to retain the VBA code. Thanks!
@tonitoni9368
2 жыл бұрын
Very good video Is it possible that several users can log in using their own account? thanks
@thedatalabs
2 жыл бұрын
Yes, that's possible and based on project type. Thanks!
@meatloaf8055
2 жыл бұрын
Can I have a copy of module 1 code
@roycetagram
2 жыл бұрын
Excuse me which excel version has developer
@thedatalabs
2 жыл бұрын
It's 2016
@roycetagram
2 жыл бұрын
@@thedatalabs thank you sir
@DiwanSihrALbayan
2 жыл бұрын
from egypt thank you very much
@abhishekdas8503
3 жыл бұрын
Superb,I added this feature in the dynamic data Entry Form,Thank you
@faramarzakhash
7 ай бұрын
Thanks a lot for this video. This video very helpful for me......
@thedatalabs
7 ай бұрын
Thanks for your feedback!
@RajaGiri_tvpm
2 жыл бұрын
I like your teaching and your video , I learn from your video and try to create . Thank you 👍
@vitaljunior7237
4 жыл бұрын
please can you tell me on your site download these images
@charlesagyepong233
2 жыл бұрын
thank you for your video. how do i get the icons used in the video
@SameerAhmed-si2sg
2 жыл бұрын
Thanks a lot for this tutorial and effort. As always, very useful. Great bro
@prediction2302
4 жыл бұрын
Sir I think it is more useful if user can create own id and password his/ her choice .id and password save in computer head
@nikhilbhor3933
4 жыл бұрын
Nice video sir, I am going to add this feature to my userform
@nikhilbhor3933
4 жыл бұрын
Sir my userform runs a little slow while adding data to worksheet, I have lots of things going on while doing it, like sorting, copying and pasting the data, can you help me to fix it?
@dorjitshering9325
3 жыл бұрын
Thank you very much for the codes but I have one problem. How to close the login form ? Suppose if someone accidentally open it and doesn't know the password then the login form won't close, it stays there on the computer screen. (I have disabled the X button to protect my worksheet)
@AbhishekKumar-dancevideos
3 жыл бұрын
As you can see in the tutorial itself Mr Dilip has already explained there. A place where CmdClear is explained you can write the code for closing the file. It's written in video. You have to write by pausing the video. Watch carefully you will understand. You can also add an extra close command button.
@smokybench8540
4 жыл бұрын
Thanks!!! ...your tutorial was very helpful
@kayjames2784
3 жыл бұрын
Great tutorial. How do we create usernames and passwords for more than one person - assuming two, three or more people will work on the userform, add and modify information in it. Your kind help very much appreciated.
@alializadeh8195
Жыл бұрын
Thanks
@shawn83823
3 жыл бұрын
hey friend im stuck when i try to debug it give me a error on LoginInstance what can it be ?
@simischaeffer8506
3 жыл бұрын
Maybe Option Explicit you must delete Option Explicit
@kenbelen3470
4 жыл бұрын
using the same form, how to grant access to a user on their data entry only?
@kailee6823
3 жыл бұрын
thank you for this tutotial, by the way is there a way to bypass this login to open the workbook?
@aryankumar9784
4 жыл бұрын
Really nice 👌👌 video
@anjalinairu7346
4 жыл бұрын
Hey admin very use full vedio
@sonnykhak1833
3 жыл бұрын
Good video. May God bless you.
@renudesai2532
4 жыл бұрын
Hello sir, if we develop using this can multiple user use this application at the same.
@thedatalabs
4 жыл бұрын
Yes, please watch this tutorial. Thanks! kzitem.info/news/bejne/l4Kpu6GprXyAi20
@carloscesar3922
3 жыл бұрын
Hi! where did u get ur pictures from?
@hajarasmidar2311
3 жыл бұрын
Hi sir, what a wonderful sharing over here. Can you do a tutorial on how to put in a file attachment for the data entry form.
@jaspergapasin
4 жыл бұрын
Very Nice 👍👍👍 and clear tutorial
@jralfmr
3 жыл бұрын
I tried create one using this video, however everytime I try to login using the same username and password it just ends up not accepting the password. The invalid login credentials kept on popping. I even double checked the codes and tried changing it but it keeps denying access to the sample file I am experimenting with. How can I fix that?
@thedatalabs
3 жыл бұрын
Please check the condition which you are using to match the credentials. Share the line of code so that we can go through and suggest you the fix. Thanks!
@jralfmr
3 жыл бұрын
@@thedatalabs I found out the cause. I used user instead of username..
Hi, Thanks for this nice little tutorial. I have a question about the Logins. Is it possible to create an Login tracker how shows me witch user was at what date and time logged in ? Thanks in advance Bernhard
@shahwanichannel9121
3 жыл бұрын
EXCELLENT
@hakeemzahardi9207
3 жыл бұрын
The userform design is very nice and modern
@m-squaredcontractors9720
4 жыл бұрын
Thanks for an awesome tutorial. Do you do consultation for a fee?
@moubarakhalidou6418
3 жыл бұрын
Genius
@gilbertson372
3 жыл бұрын
Thanks bro 💖
@caianevans7853
2 жыл бұрын
This was a great help, much appreciated!
@jayprildejesus8407
3 жыл бұрын
thank you bro. you make my work much easier and safe
Пікірлер: 136