Beautiful Registration form with Picture in Excel VBA

Beautiful Registration form with Picture in Excel VBA | Web form look

Рет қаралды 129,576

4 жыл бұрын

#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-anexcelexpert.com/beau...
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
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-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
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-matic.com/refer/...
Laptop: amzn.to/3g1607D

Пікірлер: 240

@md.khaledmahmud7097 4 жыл бұрын

You are a genius.. Keep UserForm Visible While Other Workbooks Are Open.. Need a awesome tutorial..

@erikysilvagomes5496 2 жыл бұрын

Amazing! So interesting the way you turned the excel forms looks better than traditional!

@PKAnExcelExpert 2 жыл бұрын

Glad you think so!

@kelliereviews5341 3 жыл бұрын

I love watching videos with VBA in excel. Thank you for sharing. This will also help to enhance my vba library project.😊😜

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@braddenton1350 2 жыл бұрын

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.

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback🙏

@WojennyMlotek 4 жыл бұрын

You have an unnatural talent for making an amazing things with old, out-of-date and neglected, by MS, language such as VBA.

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@sharvari.s.vichare 4 жыл бұрын

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??

@amitbiyani7598 4 жыл бұрын

pls share code

@ilkerakyuz7322 3 жыл бұрын

Excellent tutorial ,Amazing vba code Thanks so much.......From TURKEY

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@DineshKalel 4 жыл бұрын

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.💖

@EricAstarcom 4 жыл бұрын

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.

@kkbutor 4 жыл бұрын

I've done this exact thing bfo and it wasn't easy though

@caruanagiacomo3322 2 жыл бұрын

very well explained keep it up I'm from Belgium, and have been able to follow very well and it works thank you

@PKAnExcelExpert 2 жыл бұрын

You're welcome!

@advanceexcelteach7514 3 жыл бұрын

sir aap ko dil se thanks you r best....

@berairelnour6146 2 жыл бұрын

Thanks a lot for your vedios. They are very rich with information, & very clear.

@albanoteles4924 4 жыл бұрын

Excelent! You are the Best!Thank you for sharing.

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@user-ce6ef9dy1w 8 ай бұрын

thank you so much, i was able to create an innovation for my school because of this video... more powers to you!

@PKAnExcelExpert 8 ай бұрын

Thanks🙏

@Shunpall Жыл бұрын

This is an amazing tutorial.. made it seem so easy.. Thank you for sharing!

@PKAnExcelExpert Жыл бұрын

Most welcome

@bstechnologyrajbiraj1085 4 жыл бұрын

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.

@user-io5ot6cf7d 4 жыл бұрын

All my works are more than wonderful. Greetings.

@joses.pacheco3069 3 жыл бұрын

Muito bom. Parabéns!

@NeangBona 4 жыл бұрын

Amazing vba code in this form I do like it so much PK, tq !

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@krisztianszabolcsadorjan7312 4 жыл бұрын

the same (pro) quality again, thanks a lot!

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@WildFire2028 Жыл бұрын

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?

@mustafeosman1 4 жыл бұрын

Thanks sir. U are the best. 👍👍👍🇸🇴🇸🇴🇸🇴🎉🎉🎉

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@mustafeosman1 4 жыл бұрын

PK: An Excel Expert U are 🥇 really.

@baliongerewiong2194 4 жыл бұрын

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.

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@oediarti2012 2 жыл бұрын

Thanks sir, easy to make. Salam from Indonesia

@oediarti2012 2 жыл бұрын

Easy to see, but there is no coding to apply

@oediarti2012 2 жыл бұрын

I wiill try the sample

@AMPS3008 4 жыл бұрын

Excellent tutorial

@PKAnExcelExpert 4 жыл бұрын

Glad you think so!

@eyeofthetiger8287 2 ай бұрын

Very good teaching just perfect

@PKAnExcelExpert 2 ай бұрын

Glad you think so!

@Ljresets 2 жыл бұрын

its very useful thanks for the vba excel...

@PKAnExcelExpert 2 жыл бұрын

Thanks

@KLiCuk1 Жыл бұрын

great tutorial - thank you 👍

@PKAnExcelExpert Жыл бұрын

You are welcome!

@mdexcelpro8495 2 жыл бұрын

Excellent amazing 👌👌

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback

@sportsjunkie7120 4 жыл бұрын

First to like u re legend bro

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable support.

@sharvari.s.vichare 4 жыл бұрын

Good PK

@amrutchitragar3014 4 жыл бұрын

Excellent Video Sir

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@skmanchal 3 жыл бұрын

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 .

@cbbcbb6803 5 ай бұрын

Thanks. Very good. Next, could try it with Libreoffice Calc.

@lize-marievanonselen3563 Жыл бұрын

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?

@jaisparky4874 2 жыл бұрын

Its really osm bro !😍🔥

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback

@omarmohamed3801 4 жыл бұрын

Always creative

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@indianmonster1445 3 жыл бұрын

😷😷😷😷😷😷 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......

@vision20200 3 жыл бұрын

Great! Thanks.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@jasondada5705 4 жыл бұрын

Excellent 👌

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@himanshuhalder956 3 жыл бұрын

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.

@jgun0075 3 жыл бұрын

Awesome 👍👍👍👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@chandanjena5950 2 жыл бұрын

Great ,job. Sir plz make a daybook with ledger head,and RE(receive, Expenditure)👍👍🇮🇳

@PKAnExcelExpert 2 жыл бұрын

Okay sure

@karuppusamyn515 3 жыл бұрын

sir, can recommend any xls vba import & download employee biometric fingerprint data userform? i hope you..

@boda24able 2 жыл бұрын

Great video sir

@PKAnExcelExpert 2 жыл бұрын

Thanks

@pinballwizard7927 Жыл бұрын

Awesome. Thank You

@PKAnExcelExpert Жыл бұрын

You're welcome!

@jessehardy7838 3 жыл бұрын

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?

@khushalmahemdavadiya7504 2 жыл бұрын

Super Sir, Amazing Sir i have one request pls make family data with add update all details with children phots

@georgep6963 2 жыл бұрын

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.

@pankaj4kamal 4 жыл бұрын

Awesome Sir ji.... 👍

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@pankaj4kamal 3 жыл бұрын

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

@pankaj4kamal 3 жыл бұрын

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

@mphophasha2909 Жыл бұрын

you're the best 😁

@PKAnExcelExpert Жыл бұрын

Thanks🙏

@prakashrathore8708 2 жыл бұрын

Wow .......Excellent Sirji... Real help me

@PKAnExcelExpert 2 жыл бұрын

Most welcome

@therizalmemorialcolleges-p7894 2 жыл бұрын

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! :)

@alirathore8918 2 жыл бұрын

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?

@mkradeshaha3365 4 жыл бұрын

Thanks many many thanks

@PKAnExcelExpert 4 жыл бұрын

Welcome

@superintendenttalala5623 3 жыл бұрын

Awesome

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@Telugumom138 2 жыл бұрын

i like and enjoy this video

@PKAnExcelExpert 2 жыл бұрын

Thanks

@KadatuaCreator Жыл бұрын

Good Tutorial

@PKAnExcelExpert Жыл бұрын

Thanks🙏

@hasanhunain3071 4 жыл бұрын

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?

@prediction2302 4 жыл бұрын

very ..,Nice sir ji

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@serifkrd8747 2 жыл бұрын

Teşekkürler Türkiye den Selamlar

@PKAnExcelExpert 2 жыл бұрын

En Hoş Geldiniz

@girl.dragon3289 18 күн бұрын

Thank you sir

@PKAnExcelExpert 18 күн бұрын

Welcome

@mkradeshaha3365 4 жыл бұрын

Sir iam watching your all video

@PKAnExcelExpert 4 жыл бұрын

Thanks

@mkradeshaha3365 4 жыл бұрын

Sir how to create day book in vba pls create a vedio pls request sir for you

@mkradeshaha3365 4 жыл бұрын

Pls sir tell this

@easybazar3170 Жыл бұрын

thank you so much

@PKAnExcelExpert Жыл бұрын

Most welcome🙏

@claudineyribeiro518 7 ай бұрын

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

@saifsudais 2 жыл бұрын

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.

@santoshtayade5595 2 жыл бұрын

Very Nice

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback🙏

@vkreddyvasamreddy5385 3 жыл бұрын

Good presentation. Data stored in excel with photo path. How to get report with crystal reports with excel data along with photos. Please reply

@nekruzshokirov4472 3 жыл бұрын

Thank you for your usiful lesson but i have one question can you answer

@nadirsaoud2593 4 жыл бұрын

Thanks

@PKAnExcelExpert 4 жыл бұрын

Welcome

@duraisamy4268 4 жыл бұрын

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?

@AbdulMajeed-hx4jv 2 жыл бұрын

Good 👍😊

@PKAnExcelExpert 2 жыл бұрын

Thanks 😊

@offroadies6 3 жыл бұрын

Can you please make same video for data entry into a excel table?

@proscetech1105 Жыл бұрын

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

@kkbutor 4 жыл бұрын

Please PK how can I remove the red default Exit icon on my form❎❌. Or how to assign a code to it, so that a form can't just be exited with it.

@JosephogechukwukaVictor Жыл бұрын

how did you get the click event for image? I can't seem to do that on excel 2019.

@tuncaygungor833 3 жыл бұрын

How do you fix resize problem. This form is very beatiful but Textboxs will scroll on computer with other resolution

@Mannabhav 3 жыл бұрын

Nice 👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@Mannabhav 3 жыл бұрын

Sir how to user form picture go to in excel sheet???? C:\ not a c drive

@anaksugmalik3051 3 жыл бұрын

sir what version of excel u used

@JamalMiknas 3 жыл бұрын

PK ca you tell me why if I create my own form in Powerpoint and save as picture jpeg. When I load on the form it just shows blank form with none of my text boxes or labels?

@SH52DHL 3 жыл бұрын

Make sure you select all and then "Group" in Powerpoint before saving as image.

@Marvin4sho Жыл бұрын

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?

@PKAnExcelExpert Жыл бұрын

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

@devendrashinde1939 4 жыл бұрын

Can we share excel sheet on mail through VBA

@sonatahd9877 3 жыл бұрын

wow

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@sounkakada1645 2 жыл бұрын

This video very nice thank you very much But please slow then this Abit 🙏

@PKAnExcelExpert 2 жыл бұрын

Thanks for your valuable feedback.

@srinivas3089 3 жыл бұрын

Searching with text will work well but not with number bro ...plz this small solution. Thank you 👍

@amyivori1698 2 жыл бұрын

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?

@mdnahid. 3 жыл бұрын

It's a great tutorial. I tried a project like this by seeing your tutorial. I have an issue. When I try to add a person's data whose photo is not available , so I add the data without photo, then I got an error .( FileCopy Me.txtImageURL.value, img_name) I personally tried to fix it but in vain. How could I add someones data even without his/her photo. Please help me. It took me a very long time to do this by seeing your tutorial and I don't want to give up.

@protravel. Жыл бұрын

It was nice I need your help to make marketing data sheet

@protravel. Жыл бұрын

Give your contact

@Husky_Passion 4 жыл бұрын

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.

@syedimran9406 Жыл бұрын

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

@abddulkuddusdewan9474 Жыл бұрын

Assalamu alykum, very nice & easy way to creat Reg. Form. But could u pls. add printable registered Form? Whatever Data input in user form.

@PKAnExcelExpert Жыл бұрын

I will try to add in next version

@mohamadfawaz1928 4 жыл бұрын

I wish i have .00001 of your skills

@PKAnExcelExpert 4 жыл бұрын

It is a big compliment. Thanks a lot

@Husky_Passion 4 жыл бұрын

lol

@mostafaengineer3199 3 жыл бұрын

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

@charliegriffiths2388 5 ай бұрын

31:23 calendar 📆

@biswajitbiswas4084 3 жыл бұрын

Sir I launch the registration forms but corner portion cut not showing properly .Plese help me.

@ExcelMadeEasy444 4 жыл бұрын

Sir How to Solve - We found a problem with some content .xlsm this problem?

@m.asarder3383 Жыл бұрын

Is it possible to add next and previous system with this practice excel file?

@PKAnExcelExpert Жыл бұрын

I will try to add this in next version

@helpinghand1099 2 жыл бұрын

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

@miicelltechnosv7395 Жыл бұрын

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????

@mehulmehta9382 3 жыл бұрын

i have use powerpoint 2016 but insert-icons option not available how it can

@Husky_Passion 4 жыл бұрын

why only jpeg picture ? Excel can open png, tif, gif, ...

@thorjarlberglund997 3 жыл бұрын

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 :(