Beautiful Registration form with Picture in Excel VBA | Web form look
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- #Userform #VBA
Hello Friends,
In this video you will learn a beautiful Registration form with Picture in Excel VBA. We have given a web form look to this registration form. Data will be stored in "Data" worksheet available in the same excel file. In this form we have given Add, Search, Update and Delete buttons.
Download the practice file from below given link:
www.pk-anexcel...
Download the Calendar Control in VBA from below link
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...
Laptop: amzn.to/3g1607D
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
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
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🙏
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!
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🙏
This is an amazing tutorial.. made it seem so easy.. Thank you for sharing!
Most welcome
sir aap ko dil se thanks you r best....
Very good teaching just perfect
Glad you think so!
Thanks sir. U are the best. 👍👍👍🇸🇴🇸🇴🇸🇴🎉🎉🎉
Thanks for your valuable feedback
PK: An Excel Expert U are 🥇 really.
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 a lot for your vedios. They are very rich with information, & very clear.
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
Excelent! You are the Best!Thank you for sharing.
Thanks for your valuable feedback
Amazing vba code in this form I do like it so much PK, tq !
Thanks for your valuable feedback
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
the same (pro) quality again, thanks a lot!
Thanks for your valuable feedback
Excellent tutorial
Glad you think so!
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?
Thanks. Very good.
Next, could try it with Libreoffice Calc.
great tutorial - thank you 👍
You are welcome!
its very useful thanks for the vba excel...
Thanks
😷😷😷😷😷😷
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......
Always creative
Thanks for your valuable feedback
Thanks sir, easy to make. Salam from Indonesia
Easy to see, but there is no coding to apply
I wiill try the sample
Excellent Video Sir
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
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?
All my works are more than wonderful. Greetings.
sir what version of excel u used
Super Sir, Amazing Sir i have one request pls make family data with add update all details with children phots
Thank you sir
Welcome
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
Excellent amazing 👌👌
Thanks for your valuable feedback
Great video sir
Thanks
i like and enjoy this video
Thanks
Great ,job. Sir plz make a daybook with ledger head,and RE(receive, Expenditure)👍👍🇮🇳
Okay sure
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.
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
Good Tutorial
Thanks🙏
Awesome. Thank You
You're welcome!
Wow .......Excellent Sirji... Real help me
Most welcome
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! 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 👌
Thanks for your valuable feedback
Awesome 👍👍👍👍
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
Teşekkürler Türkiye den Selamlar
En Hoş Geldiniz
Can we share excel sheet on mail through VBA
you're the best 😁
Thanks🙏
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?
Searching with text will work well but not with number bro ...plz this small solution. 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?
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.
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
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 ..,Nice sir ji
Thanks for your valuable feedback
First to like u re legend bro
Thanks for your valuable support.
Good PK
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?
Thanks many many thanks
Welcome
how did you get the click event for image? I can't seem to do that on excel 2019.
How do you fix resize problem. This form is very beatiful but Textboxs will scroll on computer with other resolution
Awesome
Thanks for your valuable feedback
Its really osm bro !😍🔥
Thanks for your valuable feedback
Thank you for your usiful lesson but i have one question can you answer
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????
Good presentation.
Data stored in excel with photo path.
How to get report with crystal reports with excel data along with photos.
Please reply
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?
Is it possible to add next and previous system with this practice excel file?
I will try to add this in next version
thank you so much
Most welcome🙏
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 .
Very Nice
Thanks for your valuable feedback🙏
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
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
sir,
can recommend any xls vba import & download employee biometric fingerprint data userform? i hope you..
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
Great! Thanks.
Thanks for your valuable feedback
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! :)
Good 👍😊
Thanks 😊
Muito bom. Parabéns!
This video very nice thank you very much
But please slow then this Abit 🙏
Thanks for your valuable feedback.
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
Nice 👍
Thanks for your valuable feedback
Sir how to user form picture go to in excel sheet????
C:\ not a c drive
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?
Can you please make same video for data entry into a excel table?
Thanks sir
Welcome
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.
Sir I launch the registration forms but corner portion cut not showing properly .Plese help me.
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
When i search by mobile number, is givem msg " No match found'. How to solve it. Please advice.
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
You did not apply any condition when user press add button without fill text box .???
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?
It was nice I need your help to make marketing data sheet
Give your contact
I am trying to calculate DateAdd in vba coding. but closing date result is showing wrong. example starting Date =01-Jul-2023, No of month 36
closing Date showing=31-Dec-1902. Because of your calendar coding. Do you have any solution
Good day i copied the codes in the search box and its not working on the visual basic everytime i click search it debugs