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.
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?
😷😷😷😷😷😷 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......
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
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
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 .
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
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?
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
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 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
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! :)
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.
To be honest I am completely novice on VBA procedures. I most appreciate the effort for this presentation, but I have to notice that, this procedure is not clear to me.. I can see there is another form - the one embeded in the excel sheet (17.06). How can I add this form in the sheet?
The type of data base I want to create is different so I started having issue with the coding to transfer it to excel kindly reply me sir I really need your assistance on it thank you
Hello, I having issue adding the picture via Microsoft visual Basic. Once I am there I tried to do the same steps but I could not make it. I have changed picture formats but still not able to do so. Please any solutions for this. I am using excel on Macbook.
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.
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????
you make awesome videos.. Wish they where set focus on differrent chapters tho.. Almost done with this video and all data got fckd.. Could not find back.. Searched for like 20 min.. And then.. :( New error :D Almost done.. Does not work :(
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
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🙏
Excellent tutorial ,Amazing vba code Thanks so much.......From TURKEY
Thanks for your valuable feedback
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
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🙏
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!
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
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
Very good teaching just perfect
Glad you think so!
sir aap ko dil se thanks you r best....
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.
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.💖
Thanks sir. U are the best. 👍👍👍🇸🇴🇸🇴🇸🇴🎉🎉🎉
Thanks for your valuable feedback
PK: An Excel Expert U are 🥇 really.
Thanks a lot for your vedios. They are very rich with information, & very clear.
Thanks sir, easy to make. Salam from Indonesia
Easy to see, but there is no coding to apply
I wiill try the sample
Great video sir
Thanks
its very useful thanks for the vba excel...
Thanks
Excellent tutorial
Glad you think so!
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?
great tutorial - thank you 👍
You are welcome!
Excellent Video Sir
Thanks for your valuable feedback
Excellent amazing 👌👌
Thanks for your valuable feedback
Excelent! You are the Best!Thank you for sharing.
Thanks for your valuable feedback
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......
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
Amazing vba code in this form I do like it so much PK, tq !
Thanks for your valuable feedback
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
Always creative
Thanks for your valuable feedback
you're the best 😁
Thanks🙏
Excellent 👌
Thanks for your valuable feedback
Its really osm bro !😍🔥
Thanks for your valuable feedback
the same (pro) quality again, thanks a lot!
Thanks for your valuable feedback
Good Tutorial
Thanks🙏
All my works are more than wonderful. Greetings.
First to like u re legend bro
Thanks for your valuable support.
Good PK
Thanks. Very good.
Next, could try it with Libreoffice Calc.
Wow .......Excellent Sirji... Real help me
Most welcome
Great ,job. Sir plz make a daybook with ledger head,and RE(receive, Expenditure)👍👍🇮🇳
Okay sure
i like and enjoy this video
Thanks
Awesome. Thank You
You're welcome!
Good 👍😊
Thanks 😊
Super Sir, Amazing Sir i have one request pls make family data with add update all details with children phots
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.
Very Nice
Thanks for your valuable feedback🙏
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
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.
Awesome
Thanks for your valuable feedback
very ..,Nice sir ji
Thanks for your valuable feedback
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
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
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
Thank you sir
Welcome
31:23 calendar 📆
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 .
thank you so much
Most welcome🙏
Thanks many many thanks
Welcome
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?
Teşekkürler Türkiye den Selamlar
En Hoş Geldiniz
Searching with text will work well but not with number bro ...plz this small solution. Thank you 👍
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
It was nice I need your help to make marketing data sheet
Give your contact
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?
Good presentation.
Data stored in excel with photo path.
How to get report with crystal reports with excel data along with photos.
Please reply
Thank you for your usiful lesson but i have one question can you answer
Muito bom. Parabéns!
This video very nice thank you very much
But please slow then this Abit 🙏
Thanks for your valuable feedback.
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?
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
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
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
sir,
can recommend any xls vba import & download employee biometric fingerprint data userform? i hope you..
Thanks sir
Welcome
Is it possible to add next and previous system with this practice excel file?
I will try to add this in next version
sir what version of excel u used
how did you get the click event for image? I can't seem to do that on excel 2019.
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?
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
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
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
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! :)
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 a one question for you
I have to search selected columns how can I do that can you help me?
Thanks
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
Can you please make same video for data entry into a excel table?
I wish i have .00001 of your skills
It is a big compliment. Thanks a lot
lol
To be honest I am completely novice on VBA procedures. I most appreciate the effort for this presentation, but I have to notice that, this procedure is not clear to me.. I can see there is another form - the one embeded in the excel sheet (17.06). How can I add this form in the sheet?
wow
Thanks for your valuable feedback
The type of data base I want to create is different so I started having issue with the coding to transfer it to excel kindly reply me sir I really need your assistance on it thank you
Hello, I having issue adding the picture via Microsoft visual Basic. Once I am there I tried to do the same steps but I could not make it. I have changed picture formats but still not able to do so. Please any solutions for this. I am using excel on Macbook.
How do you fix resize problem. This form is very beatiful but Textboxs will scroll on computer with other resolution
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.
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????
Can we share excel sheet on mail through VBA
you make awesome videos.. Wish they where set focus on differrent chapters tho.. Almost done with this video and all data got fckd.. Could not find back.. Searched for like 20 min.. And then.. :( New error :D Almost done.. Does not work :(
Thanks
Welcome