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! :)
@QuinvieGaming
Жыл бұрын
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!
@RobertRudzek
Жыл бұрын
Hiii! First of all, super helpful video.
@stems88
Жыл бұрын
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.
@MelCompton
Жыл бұрын
Hello! I am working on a tutorial on how to do this. It will be out soon!
@mikerobertson1184
Жыл бұрын
@@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?
@nyga637
Жыл бұрын
Yes please!!!!
@talkky
8 ай бұрын
Would love to see this too!
@holliereid7310
8 ай бұрын
@MelCompton do you have the link for this please?
@marxiusbautista7364
Жыл бұрын
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? 😅
@MelCompton
Жыл бұрын
Hello! I am always looking for ideas for tutorials. Especially using VBA. :) I will definitely put this on my list! Thank you!
@tranglilytrinh6931
Ай бұрын
Hey. I have the same question and am wondering if you can share the tutorial to save to an excel spreadsheet
@shrestarshetty9338
15 күн бұрын
@@MelCompton im looking for the same . Could you please share the tutorial
@michaelthelwell9343
Ай бұрын
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
27 күн бұрын
Is this information you will be filling in or will they be filling it in?
@michaelthelwell9343
26 күн бұрын
@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
@jenniferbudurka3910
9 ай бұрын
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.
@mariaelenaarango5193
3 ай бұрын
my submit button doesn't work
@MelCompton
18 күн бұрын
Hi! Are you getting an error?
@nirranjankaayatek9200
Жыл бұрын
I truly appreciate your exceptional effort in meticulously addressing nearly every specific requirement for those Excel forms. Thank you for your outstanding work!
@abhishekkamble9895
26 күн бұрын
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
19 күн бұрын
Is the code crashing Excel before it closes or you restart your computer?
@abhishekkamble9895
19 күн бұрын
@@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. 👍👍
@MelCompton
17 күн бұрын
Remove the code to upload to the onedrive and see if it crashes.
@abhishekkamble9895
9 сағат бұрын
@@MelCompton I got to know VBA don't run on Android devices. But does it run on windows OS tablets..?
@VinylCraftWorkShops
8 ай бұрын
But what if you have multiple people filling out the form?
@braingenius5686
2 ай бұрын
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?
@MelCompton
27 күн бұрын
Hi, if you are wanting a running list of entries you would be better off doing this within Microsoft forms online.
@RonaldSnee
7 ай бұрын
You missed spelled appreciated in your form
@MumbleCuss
6 ай бұрын
Thank you! This was very helpful.
@rfdave3980
Жыл бұрын
I am Boring (normal) but not anymore thanks to your video. Thanks you Melissa. More please ....
@MelCompton
Жыл бұрын
Thank you! I'm glad it helped!
@PureSearch-bw3li
5 ай бұрын
Your style is easy to follow. You are a brilliant and a super effective teacher!
@J8MediaInovations
3 ай бұрын
Also I wanted I want this data to go into a data sheet.
@GinGinA702
8 ай бұрын
How can I add multiple email recipients or can it only be 1 To, 1 CC, & 1 BCC?
@alisharagusa5595
Жыл бұрын
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?
@MelCompton
Жыл бұрын
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.
@shipleysweden5565
Жыл бұрын
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.
@MelCompton
Жыл бұрын
Hello! Yes but it will take some extra VBA code. I will get it written and tutorial put out as soon as I can.
@rohitnate1
7 ай бұрын
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?
@chrisstaniland5271
8 ай бұрын
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.
@yesitsme8943
Жыл бұрын
Thank you! It would be great if there was a good solution like this for Excel for Mac.
@MelCompton
Жыл бұрын
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!
@vincebaker3384
2 жыл бұрын
Can you make a Fillable Form With A Submit Button In Libre office
@MelCompton
2 жыл бұрын
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. kzitem.info/news/bejne/qoBnyXuqZpqgo6g
@dianrose2547
9 ай бұрын
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 -
@J8MediaInovations
3 ай бұрын
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.
@MelCompton
3 ай бұрын
Hi! Unfortunately VB code is not compatible with MAC or web versions of 365.
@J8MediaInovations
3 ай бұрын
@@MelCompton omg :( any work around?
@buzzinpenguins
6 ай бұрын
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.
@DeeInkersole
2 ай бұрын
Really helpful video. Very clear and not too roomy.
@MelCompton
27 күн бұрын
You are very welcome! I'm happy it helped you!
@shacareedixon9779
2 жыл бұрын
Can I ask why would someone want to use Excel to make a fillable form instead of using word? Does excel offer more functions? I'm just a beginner with office.
@MelCompton
2 жыл бұрын
Hello! Welcome to MS Office! Excel allows the use of databases to verify and auto-populate data in the form. Word does not have this capability. Starting around 5 minutes into the tutorial, I explain this in depth. :)
@lindanay4933
Жыл бұрын
I'm not sure. I noticed one difference is Word would have prompted that Appreciation is misspelled and I didn't see Excel prompt a spell correct. I'm here trying to learn Excel as well. Maybe Excel has a spell check box? Maybe it doesn't? I just wouldn't want to send out my form to my entire company with my spelling mistake in bold upfront & center. I think I would rather trust Word to spell check for typos. Spelling aside, this is a well thought out and explained tutorial. Thanks!
@shy_boyjosh644
8 ай бұрын
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
@Mbartn
Жыл бұрын
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 👏👏🫶
@MelCompton
Жыл бұрын
Thank you! I'm glad it helped!
@SoltecPMs
Жыл бұрын
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.
@gayedougherty1941
5 ай бұрын
Hello, Melissa! So sorry for the confusion. Yes, it was for you!
@GlennRichardson
10 ай бұрын
Great video/tutorial. Thank you. Is there a way to just send one Worksheet, rather than the whole file?
@gospelmoto2833
Жыл бұрын
Great Video. Thanks for sharing.
@MelCompton
Жыл бұрын
Thank you! I'm glad it helped!
@SEDSeanBrown
Жыл бұрын
Hello my name is sean brown and I have an issue with the submit button function will you be able to assists
@ClaireOgden-m8r
Жыл бұрын
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?
@urdecisionisurs
6 ай бұрын
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.
@RenatoSoto-p4y
8 ай бұрын
Is there a way to type custom text on a cell that has a list in it?
@gayedougherty1941
5 ай бұрын
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!
@MelCompton
5 ай бұрын
Hi. Is this for someone else? I’m Melissa, not Sharon. :)
@davidwayne9982
Жыл бұрын
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.
@MelCompton
Жыл бұрын
Thank you! Glad it was helpful!
@burhanuddinnahid7285
Жыл бұрын
Please let me tell about to: is put my email address??
@makaii11
8 ай бұрын
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.
@MelCompton
8 ай бұрын
Hi! If you are using Microsoft 365 online I recommend doing this to forms.
@petesmit33
7 ай бұрын
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?
@MelCompton
7 ай бұрын
Hi! Yes that is correct. If they do not have outlook I would recommend using Google forms.
@jeangreen432
4 ай бұрын
Great video, thank you so much!!
@webspierre9296
Жыл бұрын
Great lesson, Melissa. I appreciate your support.👏🏿
@MelCompton
Жыл бұрын
Thank you! I'm glad it helped!
@bethlamb5643
3 ай бұрын
Thank you! I really enjoy your tutorials!
@sharleejohnstonbrosnan2854
5 ай бұрын
Thank you so much Melissa! You are an excellent teacher.
@myfuture1164
9 ай бұрын
"Super se Upper". Thank You !!
@noochy12
Жыл бұрын
Hi Melissa, is there a way to have the metadata, attached to the submission, populate another spreadsheet in mobile version?
@MelCompton
Жыл бұрын
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.
@aaronsanders5182
2 жыл бұрын
Hey Melissa, If you email this to 200 employees (for example), can you add code so that, once they click the submit button, all their responses are combined(consolidated) into one big excel spreadsheet/database, that then comes back to you? So you don't have to open 200 hundred different emails?
@brianwarner493
Жыл бұрын
A simple solution that I use for that kind of thing is making a Google Form that live fills a Google Sheet, then I query that sheet to an Excel doc. Then I just share the Form link and *Bam*, my excel pulls all the data on refresh.
@gbengahussein6922
2 жыл бұрын
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?
@MelCompton
Жыл бұрын
Hello! Sorry for the delayed response. What you are looking to do could be accomplished using either Microsoft 365 Forms or Google Forms.
@cheerbear9059
10 ай бұрын
Great video! Thanks for sharing
@MuhammadQasim-tj8ml
10 ай бұрын
vey hot
@deliacontreras4537
Жыл бұрын
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?
@MelCompton
Жыл бұрын
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.
@timothyhousman4063
Жыл бұрын
@@MelCompton Please let me know when this "Form to Database" tutorial is available, it would be very helpful. Thank YOu
Пікірлер: 100