So unbelievably greatful for this video you have shared with simple people like myself. Modifing your example to fit my needs is going to save time that can't possible be measured. MayGod Bless You and your family! Thank you.
Thanks for the master piece. Really appreciate it. Waiting for Tutorial on Userform login. First the person must register and after registration, if the username and password matches with the one on the sheet, user is allowed login to another userform. However, if he fails to register, user is remained to register first and then allowed to login to another userform. Thanks for sharing this video with us. Look forward to future tutorial on this userform.
This video is very helpful in my working place. Thank a lot sir and I have one problem "Student Fee management in Excel VBA" sir please make one video.
Dear Sir Plzz help in the same project .. i have Put the designation and Employee ID field. and for the same, I want to generate a unique alphanumeric id. Default alphabet as "EC" & the first letter of designation then 3 digit field example "EC-H-001" (EC is the default, H is "HR" from Designation selection and "001" is entry Sequence for HR) working as, while selecting designation then Employee Id TextBox is filled with generated Employee Id
Dear Sir I did it... Now my project working with auto genrate employee ID.. Code used. Dim LstRow As Long 'Figure out Last Value in Range Dim OVal As String 'Old Value Dim NVal As String 'New Value With Sheet1 If .Range("A2") = "" Then .Range("A2") = "AAFL0001" Else LstRow = .Cells(Rows.Count, "A").End(xlUp).Row OVal = .Range("A" & LstRow) NVal = "AAFL" & Format(Right(OVal, 4) + 1, "0000") Me.TextBox1.Value = NVal End If End With
😷😷😷😷😷😷 how to set letteped header footer in Excel via VBA ....like show header footer show after check box tic mark....... because some time header footer use / like emergency use ........ so please make above vba........... & how lock image in particular area in excel sheet.... Great tutorial in situation..... wow....... Great......
I have successfully created this tutorial. I'm very impressed. Keep up the good work. Just one update I like to see. When you do a search either by name or phone number, I would like to see the rows in the "Data" highlighted accordingly. Can you update us on how to do this?
Thank you very much for sharing this, this helped me allot! I just have one question; from the image path I want the image to display in another sheet cell range...how can I do that?
Thank you very much. Strong program. There is a weakness in Search with numbers. He recognizes them only when they have letters and numbers in the cell. There is a way to fix it.
I have waited for something like this for so long, wonderful video pk, keep it up, this is perfect would you mine inserting a profile printing button as well if posiible Otherwise thanks alot.
This is a great tutorial, thanks. I followed all the steps. But I have a challenge. The userform only adds data in ONE ROW. Even when I enter a new record after the first one, it just replaces the data I entered previously. How do I fix this?
Please define your last row perperly. You can see it in our code. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
This is a very helpful Video and i learned alot from it, i am having one problem tho, when i run it and try to add..it errors out with a bad file name for the photo..where should i locate the "images" file?
Amigo, vc disponibiliza seus projetos nesses vídeos ou vende? Todas as páginas que você disponibiliza não é possível encontrar o local para download. Pode me informar? São vários projetos que gostaria de baixar, mas nao encontro o local de download
Great! It's working perfectly but when I click on add without filling out the form it saves the place holders as the data. How do I avoid that. Secondly, I want to save the images by users' name and not by dd-mm-yyyy. Thanks
Excellent work 👍👍 plz guide, while generating a report for registered person how the images will show in exported filed directly. Like if I want to filter person details , no images will show , only image path will get .
Thanks for the good job. God blessyou. However, on the update code, the CLong is not accepted in mine. I don't know what to do. please what is the way forward?
You have done a great job. But in my case the data starts with column C and row number 5 in my sheet. Above are some headings and details. So please tell me how to search data in “User Form” from excel sheet by ID number or name etc. What code do I need to write for this? Please help me ASAP.
Hello Sir, I have followed you steps in making database, I am using it now to manage students enrollment forms, I just want to ask if I can insert the code of adding photo to my existing VBA form? How? Thank you in advance! :)
thank you for your reply but sorry to say I didn't get the code of this form. Please tell me where I will get the codes ? I am struggling for search button coding. Thank you
Thank you for sharing this. I tried creating this form, however encountered a problem. When I connect my laptop to an external monitor, the images and buttons on the userform get displaced or zoomed in. It works fine when I'm using only my laptop screen, but when I have 2 screens in use (one of my laptop and the other of an external monitor), that is when the issue occurs. Would you happen to know how this problem can be fixed?
if inside the sheet you put a copy of the real photo, it will be faster and no problem if the photo gets deleted. The only downside is the workbook gets bigger. But faster and more secure has way more value.
If we add mobile no with alphabet then to search with the alphabet and no the data can get but we added only with number shows no match please reply for the pbm
@@PKAnExcelExpert i want a school databse where i can Search by Class Section and Roll. Class and section in Dropdown And Roll in text box plz make a video for that
I have a problem with txt_box to browse image. My code dosen't works fine. I'm using Excel 2019, this is the problem version? the code not wrong: img_image_URL img_Photo and img_Browse is Ok. But the code don't execute: img_Browse_Click() button ... Private Sub img_Browser_Click() Dim img As String img = Application.GetOpenFilename(FileFilter:="Jpeg images, *.jpg", Title:="Select image") If Dir(img) "" Then Me.txt_image_URL.Value = img Me.FotoID.Picture = LoadPicture(img) End If End Sub Any trouble????
Hi , How to create a fit pdf by selecting the scroll button. I have a 20 of different Excel sheets. I want to select particular one and make it a print. How to achieve this?
You have an unnatural talent for making an amazing things with old, out-of-date and neglected, by MS, language such as VBA.
Thanks for your valuable feedback
How can we get the icon button in MS Power Point on Shape.
From where should it came in your Microsoft Power Point in Shapes and in MS Excel??
pls share code
Excellent tutorial ,Amazing vba code Thanks so much.......From TURKEY
Thanks for your valuable feedback
You are a genius.. Keep UserForm Visible While Other Workbooks Are Open.. Need a awesome tutorial..
thank you so much, i was able to create an innovation for my school because of this video... more powers to you!
Thanks🙏
sir aap ko dil se thanks you r best....
Amazing! So interesting the way you turned the excel forms looks better than traditional!
Glad you think so!
This is an amazing tutorial.. made it seem so easy.. Thank you for sharing!
Most welcome
very well explained keep it up I'm from Belgium,
and have been able to follow very well and it works thank you
You're welcome!
I love watching videos with VBA in excel. Thank you for sharing. This will also help to enhance my vba library project.😊😜
Thanks for your valuable feedback
Very good teaching just perfect
Glad you think so!
So unbelievably greatful for this video you have shared with simple people like myself. Modifing your example to fit my needs is going to save time that can't possible be measured. MayGod Bless You and your family! Thank you.
Thanks for your valuable feedback🙏
Thanks for the master piece. Really appreciate it. Waiting for Tutorial on Userform login. First the person must register and after registration, if the username and password matches with the one on the sheet, user is allowed login to another userform. However, if he fails to register, user is remained to register first and then allowed to login to another userform. Thanks for sharing this video with us. Look forward to future tutorial on this userform.
I've done this exact thing bfo and it wasn't easy though
Thanks sir. U are the best. 👍👍👍🇸🇴🇸🇴🇸🇴🎉🎉🎉
Thanks for your valuable feedback
PK: An Excel Expert U are 🥇 really.
Excellent tutorial
Glad you think so!
Thanks a lot for your vedios. They are very rich with information, & very clear.
great tutorial - thank you 👍
You are welcome!
Excelent! You are the Best!Thank you for sharing.
Thanks for your valuable feedback
Great video sir
Thanks
This video is very helpful in my working place. Thank a lot sir and I have one problem "Student Fee management in Excel VBA" sir please make one video.
Thanks sir, easy to make. Salam from Indonesia
Easy to see, but there is no coding to apply
I wiill try the sample
its very useful thanks for the vba excel...
Thanks
Sir iam watching your all video
Thanks
Sir how to create day book in vba pls create a vedio pls request sir for you
Pls sir tell this
Excellent Video Sir
Thanks for your valuable feedback
i like and enjoy this video
Thanks
the same (pro) quality again, thanks a lot!
Thanks for your valuable feedback
you're the best 😁
Thanks🙏
Awesome. Thank You
You're welcome!
Excellent amazing 👌👌
Thanks for your valuable feedback
Always creative
Thanks for your valuable feedback
Wow .......Excellent Sirji... Real help me
Most welcome
Teşekkürler Türkiye den Selamlar
En Hoş Geldiniz
Amazing vba code in this form I do like it so much PK, tq !
Thanks for your valuable feedback
All my works are more than wonderful. Greetings.
Thanks. Very good.
Next, could try it with Libreoffice Calc.
Good Tutorial
Thanks🙏
Awesome Sir ji.... 👍
Thanks for your valuable feedback
Dear Sir Plzz help
in the same project .. i have Put the designation and Employee ID field. and for the same, I want to generate a unique alphanumeric id. Default alphabet as "EC" & the first letter of designation then 3 digit field example "EC-H-001" (EC is the default, H is "HR" from Designation selection and "001" is entry Sequence for HR)
working as, while selecting designation then Employee Id TextBox is filled with generated Employee Id
Dear Sir
I did it... Now my project working with auto genrate employee ID..
Code used.
Dim LstRow As Long 'Figure out Last Value in Range
Dim OVal As String 'Old Value
Dim NVal As String 'New Value
With Sheet1
If .Range("A2") = "" Then
.Range("A2") = "AAFL0001"
Else
LstRow = .Cells(Rows.Count, "A").End(xlUp).Row
OVal = .Range("A" & LstRow)
NVal = "AAFL" & Format(Right(OVal, 4) + 1, "0000")
Me.TextBox1.Value = NVal
End If
End With
First to like u re legend bro
Thanks for your valuable support.
Good PK
Awesome 👍👍👍👍
Thanks for your valuable feedback
😷😷😷😷😷😷
how to set letteped header footer in Excel via VBA ....like show header footer show after check box tic mark.......
because some time header footer use / like emergency use ........
so please make above vba...........
& how lock image in particular area in excel sheet....
Great tutorial in situation.....
wow....... Great......
Its really osm bro !😍🔥
Thanks for your valuable feedback
You are simply great Sir Ji. Just one suggestion that make database as mdb file & make this userfom full screen. Thanks for this wonderful vidio.💖
I have successfully created this tutorial. I'm very impressed. Keep up the good work. Just one update I like to see. When you do a search either by name or phone number, I would like to see the rows in the "Data" highlighted accordingly. Can you update us on how to do this?
Excellent 👌
Thanks for your valuable feedback
Thank you sir
Welcome
thank you so much
Most welcome🙏
Very Nice
Thanks for your valuable feedback🙏
very ..,Nice sir ji
Thanks for your valuable feedback
Super Sir, Amazing Sir i have one request pls make family data with add update all details with children phots
Good 👍😊
Thanks 😊
Awesome
Thanks for your valuable feedback
Thanks many many thanks
Welcome
Thank you very much for sharing this, this helped me allot! I just have one question; from the image path I want the image to display in another sheet cell range...how can I do that?
Nice 👍
Thanks for your valuable feedback
Sir how to user form picture go to in excel sheet????
C:\ not a c drive
Great! Thanks.
Thanks for your valuable feedback
This video very nice thank you very much
But please slow then this Abit 🙏
Thanks for your valuable feedback.
Thank you very much. Strong program. There is a weakness in Search with numbers. He recognizes them only when they have letters and numbers in the cell. There is a way to fix it.
Excellent tutorial. Learn more. But can u share how to search more than one data containing the same name? And akso pdf in the browse section.
Great ,job. Sir plz make a daybook with ledger head,and RE(receive, Expenditure)👍👍🇮🇳
Okay sure
I have waited for something like this for so long, wonderful video pk, keep it up, this is perfect would you mine inserting a profile printing button as well if posiible
Otherwise thanks alot.
Thanks for your valuable feedback
31:23 calendar 📆
This is a great tutorial, thanks. I followed all the steps. But I have a challenge. The userform only adds data in ONE ROW. Even when I enter a new record after the first one, it just replaces the data I entered previously. How do I fix this?
Please define your last row perperly. You can see it in our code. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
Thanks sir
Welcome
sir what version of excel u used
Muito bom. Parabéns!
Good presentation.
Data stored in excel with photo path.
How to get report with crystal reports with excel data along with photos.
Please reply
This is a very helpful Video and i learned alot from it, i am having one problem tho, when i run it and try to add..it errors out with a bad file name for the photo..where should i locate the "images" file?
Amigo, vc disponibiliza seus projetos nesses vídeos ou vende? Todas as páginas que você disponibiliza não é possível encontrar o local para download. Pode me informar? São vários projetos que gostaria de baixar, mas nao encontro o local de download
Nice video.
Please tell me , if you have same names of different persons then how can we search or edit etc in this registration form?
Thank you for your usiful lesson but i have one question can you answer
its very hansom
sir,
can recommend any xls vba import & download employee biometric fingerprint data userform? i hope you..
Can we share excel sheet on mail through VBA
I like your tutos very much. I am from Brazil and started sharing my tutos on how to use OpenGL with VBA in my channel Programando em Excel para todos
Searching with text will work well but not with number bro ...plz this small solution. Thank you 👍
Thanks
Welcome
Great! It's working perfectly but when I click on add without filling out the form it saves the place holders as the data. How do I avoid that. Secondly, I want to save the images by users' name and not by dd-mm-yyyy. Thanks
Excellent work 👍👍 plz guide, while generating a report for registered person how the images will show in exported filed directly. Like if I want to filter person details , no images will show , only image path will get .
It was nice I need your help to make marketing data sheet
Give your contact
how did you get the click event for image? I can't seem to do that on excel 2019.
Thanks for the good job. God blessyou. However, on the update code, the CLong is not accepted in mine. I don't know what to do. please what is the way forward?
there is a bug, when I don't add a picture it shows errors, there should be a way to add people without a picture, could you fix this please
You have done a great job. But in my case the data starts with column C and row number 5 in my sheet. Above are some headings and details. So please tell me how to search data in “User Form” from excel sheet by ID number or name etc. What code do I need to write for this? Please help me ASAP.
wow
Thanks for your valuable feedback
Can you please make same video for data entry into a excel table?
Hello Sir, I have followed you steps in making database, I am using it now to manage students enrollment forms, I just want to ask if I can insert the code of adding photo to my existing VBA form? How? Thank you in advance! :)
Assalamu alykum, very nice & easy way to creat Reg. Form. But could u pls. add printable registered Form? Whatever Data input in user form.
I will try to add in next version
Is it possible to add next and previous system with this practice excel file?
I will try to add this in next version
very good, Will i get the codes in text file
Thanks. You can get the code in the same file. Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
thank you for your reply but sorry to say I didn't get the code of this form. Please tell me where I will get the codes ? I am struggling for search button coding.
Thank you
Thank you for sharing this. I tried creating this form, however encountered a problem. When I connect my laptop to an external monitor, the images and buttons on the userform get displaced or zoomed in. It works fine when I'm using only my laptop screen, but when I have 2 screens in use (one of my laptop and the other of an external monitor), that is when the issue occurs. Would you happen to know how this problem can be fixed?
I wish i have .00001 of your skills
It is a big compliment. Thanks a lot
lol
if inside the sheet you put a copy of the real photo, it will be faster and no problem if the photo gets deleted.
The only downside is the workbook gets bigger. But faster and more secure has way more value.
If we add mobile no with alphabet then to search with the alphabet and no the data can get but we added only with number shows no match please reply for the pbm
How do you fix resize problem. This form is very beatiful but Textboxs will scroll on computer with other resolution
You are very good please how can you help me create for my own template I'm really finding it difficult to create kindly help me
Hello sir I have a one question for you
I have to search selected columns how can I do that can you help me?
Thanks
if i Want to Add Conditional Serach By Dropdown How I Do It?
Will add in next version
@@PKAnExcelExpert i want a school databse where i can Search by Class Section and Roll. Class and section in Dropdown And Roll in text box
plz make a video for that
Awesome,but i have a problem with Search By Mobile Number,its nor working and showing No Match Found message
Please help me out ,thanks
I have a problem with txt_box to browse image. My code dosen't works fine. I'm using Excel 2019, this is the problem version? the code not wrong: img_image_URL img_Photo and img_Browse is Ok. But the code don't execute: img_Browse_Click() button ...
Private Sub img_Browser_Click()
Dim img As String
img = Application.GetOpenFilename(FileFilter:="Jpeg images, *.jpg", Title:="Select image")
If Dir(img) "" Then
Me.txt_image_URL.Value = img
Me.FotoID.Picture = LoadPicture(img)
End If
End Sub
Any trouble????
Sir I launch the registration forms but corner portion cut not showing properly .Plese help me.
Hi ,
How to create a fit pdf by selecting the scroll button.
I have a 20 of different Excel sheets. I want to select particular one and make it a print.
How to achieve this?