Really good video, nice presentation and good explanations how you walk through everything. But using Macros is using VBA, so might be good to throw that out there so people understand. As I'm sure you know, the Macro records the VBA. It's just an easy way to create a VBA script and to call on it.
This is lovely. Just one thing, macro is still active in the button even if you say it's inactive (grey), so if you click it while it's grey, maybe it still submit incomplete values. Correct me if I'm wrong.
Wow... This is great. I got everything except activation of the Submit button ✅. Could you please share the last thing you wrote under the conditional formatting menu
Thanks for this tutorial. In your next version, please enhance the functionality to include Edit, Delete, and the Search features. Very well presented.
You can use the labels of the radio buttons instead of entering "Male" and "Female" into the gender cell. Also, by moving the gender selection to the last (8th, in this case), it will automatically calculate the submit button validation without having to click outside the form cells. This works because the form doesn't reset the gender value to nil. This gives a boost to UI and data entry speed since you can keep the workflow within the cells of the form and avoid an unnecessary double-click. Overall, it is a good tutorial for simple forms, but I would point out that Excel macros are recorded in Visual Basic, so the forms do use VB and will require you to save the workbook as a macro-enabled workbook for the functionality to work. Also, if you make a mistake in the macro recording, you will either have to edit the code in VB or re-record the macro.
i find this video very interesting to learn about macro and thanks for that accordingly I also want to know how one do edit once it is submitted to the table.?
you can add the function that the button activates inside an if statement of the button with the prerequisites you need (like not having all the fields entered). If they are not met, you can redirect the code somewhere else, for example making a popup saying that the data is incomplete. this way, it will not add to your table, but you will also get a visual confirmation that the submission was not successful.
@excelhunar, Thank you for this great video! a nice presentation and good explanations how you explain things. i do have a question though, if i share this same file from onedrive, will the Marco be blocked?
Thanks for the great lesson, i just created this form, but how can I enter previous data set that i had entered manually before having this form? Can i simply copy them from my external file and paste them to the data sheet in this form?
I've been looking for such a video. May I please know if the Excel file is shared, can multiple users enter data at the same time and the file will still work correctly from transferring the data from the form to the Data tab? Will they not overlap each other? Thank you! :)
Wow 😳. This is wonderful 👍. You have done well. I just learnt something new. Thanks. If I should send the form out for people to fill, will I still get the table filled Automatically? Pls how can I achieved that?
Found this video extremely useful, is there a way to use this if I need to protect the sheets.... I get an ERROR for the macro not being able to run because I protected the sheets. Any help will be very much appreciated
Super video, but, the Macro was a surprise ending. Can you demo how to setup so that the workbook can be edited by multiple users, with no macro restrictions (Excel Online)
Hey Liam, I hope you're doing well! I was just wondering if you happened to find a solution to this question? If you did, could you please share it with me? I'd really appreciate it! Thanks a lot!
anything that is automated in excel beyond cell functions (like Macros) will have some form of VBA programming connected to it. There is no way that I know of to process such a dashboard without VBA
If I want to develop my own table as per requirement, need some fields to be blanks and click on submit button. kindly please assign the demo with blank fields also, it's mandatory 🎉
Control+A; Alt; H; O; I - Control+A selects all the cells containing data that is adjacent to the cell you have selected. Alt is the shortcut to access your menu, H goes to the Home option, O goes to the Format Sub-menu, and I selects the "Autofit column width" option. This is just to resize all your column sizes to match the size of the data contained in it.
Nice video, I loved the SUBMIT button conditional formatting part but it is not running at my end. The moment I copy the formula the whole status bar becomes grey. Could you help me understand what step I am missing?
you must cut and paste the cell, if you copy it, it will also move your reference cells for the formula (e.g. if you copy it 2 cells to the left, your reference will also move 2 cells to the left). cutting and pasting will keep the references the same.
Hi im not sure if ive skipped any steps but every time i submit new data it overwrite the previous entry. it did not copied to next row. How do i fix it to ensure when i make new submit it will be copied to the below row?
Hello. I do not have an option to paste as image, is there an alternative to have the same effect on the submit button. I will appreciate any assistance
👉👉Coding Channel : www.youtube.com/@KhanamCoding
Thanks!
Really good video, nice presentation and good explanations how you walk through everything. But using Macros is using VBA, so might be good to throw that out there so people understand. As I'm sure you know, the Macro records the VBA. It's just an easy way to create a VBA script and to call on it.
Fantastic step by step, ez to follow video. thanks so much!!!
Excellent quick & simple teaching video
I really enjoy this tuition wow! I did it exactly.🎉😊
Very helpful maula aap ko taraki de
Wow, this tutorial is amazing! I've learned so much from it. Thank you so much for generously sharing your knowledge with me.😊😊👏👏👏👏
A very clear explanation I will be looking for more of your videos
I felt silly after watching this video, I thought I knew Excel! Very nicely done video.
This is lovely. Just one thing, macro is still active in the button even if you say it's inactive (grey), so if you click it while it's grey, maybe it still submit incomplete values. Correct me if I'm wrong.
i tried it and yes is does.
Yes I am also facing same issues
after the macro is recorded, you can edit the macro and add an if statement, preventing the data processing if the data is not complete
What is the solution to this problem
@@Xynodras How to properly write the script for this one?
Been truly helpful for a newbie at creating data entry forms. Thank you! Your explanation were so easy to understand and follow. :)
Worth a try with large data entries. Thank you
Wow... This is great. I got everything except activation of the Submit button ✅. Could you please share the last thing you wrote under the conditional formatting menu
Excellent Mashallah
Great Effort
Keep up
Thank you very much. I learnt something new today.
Yep! very good video managed to get everything working.
very nice work keep it up assisting people thank you for the great work
this was the best vid i've seen today, thanx alot
Dear, that was an excellent video! Thank you
Excellent teaching Miss thanks 🇵🇰
Thanks for your demo, I tried it with little mistakes. Nambootiri Mysore
Thanks a lot for explaining so clearly and upto the point 🙏🙏🙏
your amazing and smart and that's clear explanation 🎉🎉🎉🎉🎉🎉
Thanks for this tutorial. In your next version, please enhance the functionality to include Edit, Delete, and the Search features. Very well presented.
Thank you my teacher. Hope god bless you always
Thank you very much. You are teaching this theory very well. I subscribe you
It's a great video for example. Thank you very much.
This is very helpful. Thank you very much.😍
Thank you! I've learnt some useful tips.
I like your explanation.I have followed all steps explained. My question is how can I input ID image to the form?
Very useful video - this has solved a problem I was having at work.
Amazing work
Wonderful video ❤. I wonder how good your knowledge is , for your young age.
Thank you, your step-by-step instructions were phenomenal, loved it. I created the spreadsheet exactly how I wanted it.
Good, this tutorial a amazing! i'll to do thank you!
Really appreciate your video class ❤
Thank you so much for your vivid explanation on every step in the process.
Thanks lot mam. Your way of explanation is very excellent, hats off to your job 🙏🙏
Thank you, so informative.
This video is very clear and concise. Thank you! I am curious and have a question. Could deselecting the radio button also be a part of the macro?
Excellent video, Thanks
Thanks a lot. I am learning. Thank you so much Uploader!
You can use the labels of the radio buttons instead of entering "Male" and "Female" into the gender cell. Also, by moving the gender selection to the last (8th, in this case), it will automatically calculate the submit button validation without having to click outside the form cells. This works because the form doesn't reset the gender value to nil. This gives a boost to UI and data entry speed since you can keep the workflow within the cells of the form and avoid an unnecessary double-click. Overall, it is a good tutorial for simple forms, but I would point out that Excel macros are recorded in Visual Basic, so the forms do use VB and will require you to save the workbook as a macro-enabled workbook for the functionality to work. Also, if you make a mistake in the macro recording, you will either have to edit the code in VB or re-record the macro.
Yes, any expert in Excel would know that Macros mean VBA.
I have learnt so much. Thank You
Thank you very much. It's helping me a lot for the certificate issuing n production data collecting.
YOU ARE THE BEST TUTOR
Thank you for this video. It helped me a lot. Hope to see more. 👍
Thanks very much - really useful!
This is great! Thank you!
VERY NICE PRESENTATION
This video is so easy to understand.
Thanks, you have being a blessing to me
The Video best video ever
Very well explained. Simple and concise. Great job, learnt something very useful. Thank you.
Very help full . Thank you
Thank you so much.
You have helped me
Fantastic tutorial!
thank you -very useful video
Wow! This is what I needed. Great. Very informative so I subscribed immediately :). Kudos to you
Hello
Your getting any error after submit button click that still it's not clear the previous data
i find this video very interesting to learn about macro and thanks for that accordingly I also want to know how one do edit once it is submitted to the table.?
Can you also do a VBA or Macro to make the "Submit" button on deactivated mode unless all the fields are filled out?
you can add the function that the button activates inside an if statement of the button with the prerequisites you need (like not having all the fields entered). If they are not met, you can redirect the code somewhere else, for example making a popup saying that the data is incomplete. this way, it will not add to your table, but you will also get a visual confirmation that the submission was not successful.
Great job. Learnt a lot.
Really well done!
@excelhunar, Thank you for this great video! a nice presentation and good explanations how you explain things. i do have a question though, if i share this same file from onedrive, will the Marco be blocked?
Great and well explain video, can this be done in google sheet?
Excellent!!!!
thank you i learned a lot
Just great❤
This video really help me a lot !! Thank youuu !
NICE elaborate
Brilliant
Thanks for the great lesson, i just created this form, but how can I enter previous data set that i had entered manually before having this form? Can i simply copy them from my external file and paste them to the data sheet in this form?
Thank u very much 👍👍
NICE , but can i change new data position? mean the 2nd data add at below not above database
I've been looking for such a video. May I please know if the Excel file is shared, can multiple users enter data at the same time and the file will still work correctly from transferring the data from the form to the Data tab? Will they not overlap each other? Thank you! :)
this is nice and i like it, thank you
thank you for this.
Can the macro button be activated only after the button turns blue?
Wow 😳.
This is wonderful 👍.
You have done well.
I just learnt something new.
Thanks.
If I should send the form out for people to fill, will I still get the table filled Automatically?
Pls how can I achieved that?
Found this video extremely useful, is there a way to use this if I need to protect the sheets.... I get an ERROR for the macro not being able to run because I protected the sheets. Any help will be very much appreciated
Super video, but, the Macro was a surprise ending. Can you demo how to setup so that the workbook can be edited by multiple users, with no macro restrictions (Excel Online)
Hey Liam, I hope you're doing well! I was just wondering if you happened to find a solution to this question? If you did, could you please share it with me? I'd really appreciate it! Thanks a lot!
anything that is automated in excel beyond cell functions (like Macros) will have some form of VBA programming connected to it. There is no way that I know of to process such a dashboard without VBA
Thank You. The video was very helpful. my question is, how to edit if someone entered the wrong data?
Loved this! Thank you so much
If I want to develop my own table as per requirement, need some fields to be blanks and click on submit button. kindly please assign the demo with blank fields also, it's mandatory 🎉
thank you good training
Is there a similar video but for a form to update, search or delete existing data?
Very Nice Tutorial
Thank you
Very helpful… TY. Please clarify 21:40-21:43. Ctrl ? ? ? ? Thanks🤝
Control+A; Alt; H; O; I - Control+A selects all the cells containing data that is adjacent to the cell you have selected. Alt is the shortcut to access your menu, H goes to the Home option, O goes to the Format Sub-menu, and I selects the "Autofit column width" option. This is just to resize all your column sizes to match the size of the data contained in it.
Nice video, I loved the SUBMIT button conditional formatting part but it is not running at my end. The moment I copy the formula the whole status bar becomes grey. Could you help me understand what step I am missing?
you must cut and paste the cell, if you copy it, it will also move your reference cells for the formula (e.g. if you copy it 2 cells to the left, your reference will also move 2 cells to the left). cutting and pasting will keep the references the same.
Hi im not sure if ive skipped any steps but every time i submit new data it overwrite the previous entry. it did not copied to next row. How do i fix it to ensure when i make new submit it will be copied to the below row?
Did you format that table as table (ctrl + t, while you mark the table or while you are in any of the table's cells)?
You have to copy and then press Insert (on Home tab) so the row gets shifted down, and then copied over.
Is it possible to create new sheets automatically for each data we submit
❤Thank you Soo Much sis ❤
Wow, GREAT VIDEO…. Too bad you didn’t finish it and explain why the application DOES NOT and a new record to the table!!!
Had this problem and then I rewatched and realized I didn’t follow step by step. Worked second time I tried it and continues to work.
Wonderful! Mes compliments.
Hello. I do not have an option to paste as image, is there an alternative to have the same effect on the submit button. I will appreciate any assistance
Can you please show us how to add an edit feature to this so we can edit any mistakes in any row in the data table. Thank you
By the same .if you enter employee name .other details should be automatically update.any idea pls suggest
I am from Chennai and would like to get in touch with you to know various aspects of database management in excel. How I get in touch.
I liked it❤