Hi Susan. When you go to save as there is an option in the drop down called "Excel Macro-Enabled Template." It's a .xltm extension which should work with the Visual Basic Script. Let me know if you have any issues! Thank you and have a great day! :)
Hi Melissa, this is really helpful! I hope you could also do another video, instead of sending it via email. The information will dump to another sheet on the same file. Thank you!
I truly appreciate your exceptional effort in meticulously addressing nearly every specific requirement for those Excel forms. Thank you for your outstanding work!
great video, I used some of the information you shared to create a form in excel, then the user can print it as a pdf so they can digitally sign it. thank you for sharing this.
@@MelCompton I have the same question, using excel for team to submit time-sheets and the data gathered for analysis in another workbook. Are you able to say when the tutorial will be out?
Hi Melissa C., You're a RockStar! At times(for me), Excel is an alien from another planet, 🤯. Your visual instruction is great! The topics that you cover, examples and tips that you share are perfect; most of all, your voice is not annoying 🙄 its easy listening 🙂. Their are some Excel docs I need to create at work and your video is one of the first videos I viewed👌and will be referring to it ALOT, TY 👏👏🫶
Hi Melissa! Very helpful tutorial. Could you also do another one, instead of sending an email, the data on the form is saved to an excel spreadsheet? Or maybe just share the VBA code for it if you dont want to do another tutorial? 😅
Hello! Unfortunately Microsoft Office is not native to Mac's. They do not put as much functionality into the applications for the Mac because the programming language is different. Hopefully functionality will improve in the future!
Awesom! Pls, I wanna know how to add a button that will enable the user to attach a photo from his/her file explorer. E.g. attaching proof of payment or something else. Thank you
This great! Thank-you. If I want to be the one who fills the form and sends it to the same recipient daily, (like an order form) can the “submit” button be made to disappear when the recipient opens it? Hopefully the question makes sense.
Hello, Sharon! Thank you so much for all the training you provide...so professional and well done. I do need to know how to bring back the lines on the worksheet that were deleted to create the effect of viewing a single piece of paper. I need to make changes to the form and am not able to add needed lines and information, etc. When I try to insert cells or lines it tells me I cannot "push non-empty cells off the worksheet". Thank you for your assistance!
I am using a mac and attempted to do this and everything works except the submit button. Would be nice if you showed how to go back into the VB code/macros after it was created in case you need to troubleshoot. I have no idea how to do that or solve why submit won't work. Otherwise, loved this video and I echo everyone's comments that we need the data to write into an excel spreadsheet upon submission.
Your tutorial was great, managed to make my form - was a complete basic excel user before. But i left an email address out - how can i go back in and add it to the code please?
Thank you so much!! Very helpful. A couple of questions, if you don't mind, how do we add multiple "to" emails? Do we use commas? Can I make the Subject dynamic, meaning, can I use one of the entries from the form as part of the subject? E.g. Employee: Doe, when I click submit, the email subject will be Doe Order Form. Thank you -
Hi Melissa. I really enjoyed your video to refresh my excel skills. But how do I do limit the user from clicking all boxes available. I only want them to click one. And I don't want to make a dropdown list since it's a ranking from 1-5.
Great tutorial. Thanks. Almost done with my own form. Just trying to see if I can use a Vlookiup return data, in this case an email address, as the mail reciepient in the vba code on my submit button. I need to send the form to different recipients every time. Thanks.
Thank you for the video. However, ActiveX controls are not supported on the online version of excel. And that is what we use. Is there a workaround? Thanks.
Hi mellissa, Really struggling with a task i need to complete hope you could help? I need to create a yearly work schedule for 20 engineers, which will have columns with engineer names in and the work addresses and description in rows reading from a second monthly spreadsheet. Is this possible?i am new to excel and your videos have been really useful so far
@MelCompton hi Mellissa I will be filling this information in it is work address and order numbers from several clients which will be allocated on the engineers schedules
I know you might not see this but I was wondering if there was a way where, when I click the submit button, the form could take the entries and populate a running list on another sheet within the document?
very good thank you but one question - this will only open Outlook as the mail client? what happens if the customer doesn't use Outlook as their mail client?
I followed all the steps you outlined (twice), but my Submit Form Button does not send the document via email. I'm on a iMac, does that make a difference?
Thank you for the tutorial. What if you need to use this to capture daily records in a retail shop? You do not want to send the form to anyone but just to record transactions. Is it possible to fill the form as a way of recording transactions and the records are accumulated somewhere in a database as you click submit?
I am facing an issue. I have done some VBA coding. But whenever I close excel or restarts the computer, my code doesn't work. It requires to debug. What may I have done wrong..?
@@MelCompton no. Code works very fine even after I use it after closing and reopening excel. But as soon as I restarts the computer it crashes. Actually I have set the path in code to upload the generated pdf file on cloud drive. So uploading to cloud drive may be causing the problem..? And thanks a lot for replying. 👍👍
Hi Vince. There is a way to create a fillable form with submit button in libreoffice writer. Here is my tutorial on how to do it. th-cam.com/video/IJ1cGt-hops/w-d-xo.html
Hello! If you are wanting them to fill it out and it go into a database I would recommend using Microsoft 365 online and using forms. I have a tutorial coming out for that soon.
How do I save this form as a Template
Hi Susan. When you go to save as there is an option in the drop down called "Excel Macro-Enabled Template." It's a .xltm extension which should work with the Visual Basic Script. Let me know if you have any issues! Thank you and have a great day! :)
Hi Melissa, this is really helpful! I hope you could also do another video, instead of sending it via email. The information will dump to another sheet on the same file. Thank you!
I truly appreciate your exceptional effort in meticulously addressing nearly every specific requirement for those Excel forms. Thank you for your outstanding work!
Thank you so much Melissa! You are an excellent teacher.
Hiii! First of all, super helpful video.
Thank you! This was very helpful.
I am Boring (normal) but not anymore thanks to your video. Thanks you Melissa. More please ....
Thank you! I'm glad it helped!
great video, I used some of the information you shared to create a form in excel, then the user can print it as a pdf so they can digitally sign it. thank you for sharing this.
Your style is easy to follow. You are a brilliant and a super effective teacher!
This is awesome! But I am wondering if you can make the submit button populate a table/sheet elsewhere in the workbook instead of send an email.
Hello! I am working on a tutorial on how to do this. It will be out soon!
@@MelCompton I have the same question, using excel for team to submit time-sheets and the data gathered for analysis in another workbook. Are you able to say when the tutorial will be out?
Yes please!!!!
Would love to see this too!
@MelCompton do you have the link for this please?
Hi Melissa C.,
You're a RockStar! At times(for me), Excel is an alien from another planet, 🤯. Your visual instruction is great! The topics that you cover, examples and tips that you share are perfect; most of all, your voice is not annoying 🙄 its easy listening 🙂. Their are some Excel docs I need to create at work and your video is one of the first videos I viewed👌and will be referring to it ALOT, TY 👏👏🫶
Thank you! I'm glad it helped!
Hi Melissa! Very helpful tutorial. Could you also do another one, instead of sending an email, the data on the form is saved to an excel spreadsheet? Or maybe just share the VBA code for it if you dont want to do another tutorial? 😅
Hello! I am always looking for ideas for tutorials. Especially using VBA. :) I will definitely put this on my list! Thank you!
Hey. I have the same question and am wondering if you can share the tutorial to save to an excel spreadsheet
@@MelCompton im looking for the same . Could you please share the tutorial
Really helpful video. Very clear and not too roomy.
You are very welcome! I'm happy it helped you!
Very informative, I learned a lot. ❤
Great lesson, Melissa. I appreciate your support.👏🏿
Thank you! I'm glad it helped!
Thank you!
It would be great if there was a good solution like this for Excel for Mac.
Hello! Unfortunately Microsoft Office is not native to Mac's. They do not put as much functionality into the applications for the Mac because the programming language is different. Hopefully functionality will improve in the future!
Great video/tutorial. Thank you. Is there a way to just send one Worksheet, rather than the whole file?
Thank you! I really enjoy your tutorials!
Great Video. Thanks for sharing.
Thank you! I'm glad it helped!
Thats excellent, thank you. New sub.
Awesom! Pls, I wanna know how to add a button that will enable the user to attach a photo from his/her file explorer. E.g. attaching proof of payment or something else. Thank you
This great! Thank-you. If I want to be the one who fills the form and sends it to the same recipient daily, (like an order form) can the “submit” button be made to disappear when the recipient opens it? Hopefully the question makes sense.
Hello, Sharon! Thank you so much for all the training you provide...so professional and well done. I do need to know how to bring back the lines on the worksheet that were deleted to create the effect of viewing a single piece of paper. I need to make changes to the form and am not able to add needed lines and information, etc. When I try to insert cells or lines it tells me I cannot "push non-empty cells off the worksheet". Thank you for your assistance!
Hi. Is this for someone else? I’m Melissa, not Sharon. :)
Great video! Thanks for sharing
I am using a mac and attempted to do this and everything works except the submit button. Would be nice if you showed how to go back into the VB code/macros after it was created in case you need to troubleshoot. I have no idea how to do that or solve why submit won't work. Otherwise, loved this video and I echo everyone's comments that we need the data to write into an excel spreadsheet upon submission.
Your tutorial was great, managed to make my form - was a complete basic excel user before. But i left an email address out - how can i go back in and add it to the code please?
Great video, thank you so much!!
Thank you so much!! Very helpful. A couple of questions, if you don't mind, how do we add multiple "to" emails? Do we use commas? Can I make the Subject dynamic, meaning, can I use one of the entries from the form as part of the subject? E.g. Employee: Doe, when I click submit, the email subject will be Doe Order Form. Thank you -
Hi Melissa. I really enjoyed your video to refresh my excel skills. But how do I do limit the user from clicking all boxes available. I only want them to click one. And I don't want to make a dropdown list since it's a ranking from 1-5.
Hello! Yes but it will take some extra VBA code. I will get it written and tutorial put out as soon as I can.
THANKS for these videos-- GREAT JOB-- and i don't do a lot of office stuff BECAUSE I don't know how to do stuff like this-- eager to try this one.
Thank you! Glad it was helpful!
"Super se Upper". Thank You !!
Hello, Melissa! So sorry for the confusion. Yes, it was for you!
Great tutorial. Thanks. Almost done with my own form. Just trying to see if I can use a Vlookiup return data, in this case an email address, as the mail reciepient in the vba code on my submit button. I need to send the form to different recipients every time. Thanks.
Thank you for the video. However, ActiveX controls are not supported on the online version of excel. And that is what we use. Is there a workaround? Thanks.
Hi! If you are using Microsoft 365 online I recommend doing this to forms.
Hi mellissa,
Really struggling with a task i need to complete hope you could help?
I need to create a yearly work schedule for 20 engineers, which will have columns with engineer names in and the work addresses and description in rows reading from a second monthly spreadsheet. Is this possible?i am new to excel and your videos have been really useful so far
Is this information you will be filling in or will they be filling it in?
@MelCompton hi Mellissa
I will be filling this information in it is work address and order numbers from several clients which will be allocated on the engineers schedules
I know you might not see this but I was wondering if there was a way where, when I click the submit button, the form could take the entries and populate a running list on another sheet within the document?
Hi, if you are wanting a running list of entries you would be better off doing this within Microsoft forms online.
great video
Hi Melissa, how do you add more than 1 email into the send box please
Thank you very much!
Thank you! Glad it was helpful!
Hi, I am trying to put a button directly onto my spreadsheet that will open the automatic form command to enter data into my table.
very good thank you but one question - this will only open Outlook as the mail client? what happens if the customer doesn't use Outlook as their mail client?
Hi! Yes that is correct. If they do not have outlook I would recommend using Google forms.
Hi, instead of sending it via mail can we save the data filled in the forms as customer database in another sheet in same file?
I followed all the steps you outlined (twice), but my Submit Form Button does not send the document via email. I'm on a iMac, does that make a difference?
Hello! This is only compatible on a windows machine. Microsoft does not fully code office for MAC so some of the functionality will not work.
Thank you for the tutorial. What if you need to use this to capture daily records in a retail shop? You do not want to send the form to anyone but just to record transactions. Is it possible to fill the form as a way of recording transactions and the records are accumulated somewhere in a database as you click submit?
Hello! Sorry for the delayed response. What you are looking to do could be accomplished using either Microsoft 365 Forms or Google Forms.
Is there a way to type custom text on a cell that has a list in it?
tnx a lot
But what if you have multiple people filling out the form?
Hello my name is sean brown and I have an issue with the submit button function will you be able to assists
Also I wanted I want this data to go into a data sheet.
Really Nice job but I use mac version of Excel. Mac Developer doesn't have ACTIVE X CONTROLS and it doesn't seem to excite on 365 either.
Hi! Unfortunately VB code is not compatible with MAC or web versions of 365.
@@MelCompton omg :( any work around?
Hi Melissa, is there a way to have the metadata, attached to the submission, populate another spreadsheet in mobile version?
Hello! The mobile version is not as robust as the desktop or even online version. I will take a deeper dive into this and see what can be done.
How can I add multiple email recipients or can it only be 1 To, 1 CC, & 1 BCC?
I am facing an issue. I have done some VBA coding. But whenever I close excel or restarts the computer, my code doesn't work. It requires to debug. What may I have done wrong..?
Is the code crashing Excel before it closes or you restart your computer?
@@MelCompton no. Code works very fine even after I use it after closing and reopening excel. But as soon as I restarts the computer it crashes. Actually I have set the path in code to upload the generated pdf file on cloud drive. So uploading to cloud drive may be causing the problem..? And thanks a lot for replying. 👍👍
Remove the code to upload to the onedrive and see if it crashes.
@@MelCompton I got to know VBA don't run on Android devices. But does it run on windows OS tablets..?
Can you make a Fillable Form With A Submit Button In Libre office
Hi Vince. There is a way to create a fillable form with submit button in libreoffice writer. Here is my tutorial on how to do it. th-cam.com/video/IJ1cGt-hops/w-d-xo.html
Hi, how can I edit this code to have it save to a database (data table) in the same workbook instead of sending the replies to email?
Hello! If you are wanting them to fill it out and it go into a database I would recommend using Microsoft 365 online and using forms. I have a tutorial coming out for that soon.
@@MelCompton Please let me know when this "Form to Database" tutorial is available, it would be very helpful.
Thank YOu
You missed spelled appreciated in your form
Please let me tell about to: is put my email address??
my submit button doesn't work
Hi! Are you getting an error?
vey hot