Data Entry Form with Excel Table and VLookup to Auto-Fill Default Entries

Рет қаралды 57,406

Күн бұрын

Пікірлер: 45

@stewartwilkinsonsnr 4 жыл бұрын

Awesome training video, I’m loving your channel as always been into technology in my career where we used Excel to record our daily functions,. So when I retired I thought I’m going to learn Excel and am following your videos, I am re-creating each form, writing the code rather than downloading. The satisfaction I get when I complete a project is so uplifting, and got now when I run a form and get Error message, 9 out of 10 times I know where I have gone wrong. I have a little office, so can close down and come back in the house. Thank You for all you support in producing great very informative videos. Kindest Regards Stewart, Huddersfield, UK age now 72 but feel like a 60 year old. 👍😀👏

@thedatalabs 4 жыл бұрын

Thanks for your appreciation and motivating words! Please keep supporting us and provide your feedback. Thanks! 🙏

@mr.blackbeard453 Жыл бұрын

i love you india, i don't know why ? but you always give me insight in a simple way.

@courtn580 3 жыл бұрын

Very neat! I like the concept of always inserting the first row in the table - saves having to find the last row and using a last row variable etc. Clever. One can easily sort the table after to order things the way you want

@thedatalabs 3 жыл бұрын

Thanks for your feedback! Please subscribe our channel.

@Midos7 Жыл бұрын

Thank you very much for such great video, it was very useful, keep the great work :)

@xuyenhong7357 4 жыл бұрын

What a great video! Thanks team and teacher. Keep health in good.

@jyotimoyyi3410 2 жыл бұрын

Thank you so much,god bless you

@ShamalKrishna-p8v Жыл бұрын

Awesome training video Sorry I have a Error in this section Please confirm Where am I Wrong. If objList.DataBodyRange(1, 1).Value "" Then objList.ListRows.Add Position:=1

@shaharyarmasood Жыл бұрын

i am facing same issue

@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" sir please make one video.

@thedatalabs 4 жыл бұрын

Thanks for your feedback! Will try to publish a tutorial on the suggested topic. Please keep watching and supporting us. Thanks!

@dahramu 4 жыл бұрын

Very Nice Video ... and Nice Explanation ...

@मेरोबिचार-ष7घ 4 жыл бұрын

I cant imagine.... Awesome work.. thank you...

@AbhishekMishra-cr1tz 4 жыл бұрын

Wonderful unforgettable you have explained very well Thank you very much sir

@thedatalabs 4 жыл бұрын

Thanks for you feedback!

@arnabmit 4 жыл бұрын

Amazing tutorial! Thanks a ton!

@JustAnotherFriedEgg Жыл бұрын

Thanks for this video! I am Having an issue though. When I delete the data following application.enableevents = true it doesn’t retain the auto fill as shown in the video. Paused the video and the VBA code is identical to yours so not sure as to why. Any advice? Thanks!

@andreagatti451 2 жыл бұрын

Awesome!!! But can I keep my vba form in stead? I create a nice form in vba and I’m saving data on spreadsheet. Can I use the same code to store data in tables?

@ChrisGower 3 жыл бұрын

Super useful. Was able to create a form for my sales team before a big event so they can capture meeting info. One question would be - is it possible to create this form that multiple people can use at the same time? Right now I'm going to have to create a separate excel doc for each seller, but ideally would have sellers simultaneously entering data into the form and entering together - if i try and do that now, users see other users data appearing on their doc in real time, interuptting their own data entry

@hamzagt5 3 жыл бұрын

If we are working on user form and have textbox inserted, we won't be needing to target anything, only start with the code ?

@shivannahr780 4 жыл бұрын

Thanks sir

@paulofaminial1064 3 жыл бұрын

This is awesome tutorial. i just wanna ask how will i debug this. If objList.DataBodyRange(1, 1).Value "" Then. it turns yellow when i run the form. Hope you can help me on this.

@elledragneel_spacehub4140 3 жыл бұрын

Same issue, I already tried • if objList.DataBodyRange(1,1).Value&lt>"" Then

@sourabhmistry4976 4 жыл бұрын

Great

@music_lover_313 3 жыл бұрын

Can You Make a Video On Finalizing Our VBA project To Export or distribute? So that No one can make change in the VBA Project

@thedatalabs 3 жыл бұрын

Thanks for your suggestion! I will try creating a tutorial on this topic.

@joshhattox Жыл бұрын

How do you create a form that pulls data from an existing sql data base into the form?

@youcantsay Жыл бұрын

I need help. I want to extend the formula to different column but I was unable to. Can you assist?

@mr_vhingzkybutingting7261 3 жыл бұрын

hi sir can you help to this file you share ive edit some text but cant search my input text,?

@octopus8894 4 жыл бұрын

HI i love the video! I'm trying to follow your instruction using my own table but i got stuck. It shows run time error '91':object variable or with block variable not set While i run the debugger it highlights this code If objList.DataBodyRange(1, 1).Value "" Please help thanks!

@paulofaminial1064 3 жыл бұрын

same with mine

@octopus8894 3 жыл бұрын

@@paulofaminial1064 hi I actually sorted it out a few weeks back. Just enter some words on the data table, then try and click import again. It should work.

@paulinem.5843 3 жыл бұрын

@@paulofaminial1064 Hey, I had the same issue. If I don't have anything written on the first row of the 'Database' sheet, then I get this error message. So I filled out the information for one Employee and saved the Excel like that. After doing that, the "Transfer to Table" button worked perfectly when I reopened the Excel. You can either fill out the information manually in the 'Database' sheet OR rewrite that line of code manually and then run the code using the "play" button on the Module. When doing that, the code ran normally for me. Hope this was somehow clear and helpful!