Thank You, Thank You, Thank You... This series is exactly what I was looking for. I'm using a Mac with build 16.31 and there is no Userform in that build. This is a better workaround. Your tutorials are the BEST!!
@BenDrake2008
5 жыл бұрын
A+ Excellent teacher. Clear and easy to understand tutorials. Thank you!
@arduinoguru7233
Жыл бұрын
no doubt, best excel tutorial
@aiciled1237
3 жыл бұрын
Dude this is AWESOME!!! We'll see how bullet proof it actually is.
@fransswanepoel8579
5 жыл бұрын
Thank You for the full range of tutorial. I did build a form that work 100%. But I need multiple entry in one of my dropdown box. I have the code for multiple entry but how do I link it with Macro of my form. Please can you help.
@JanBolhuis
6 жыл бұрын
Very useful and productive. An amazing video with a great explanation.
@TeachExcel
6 жыл бұрын
Thank you! I'm glad you like it!
@P0c0man8U
2 жыл бұрын
Hay that's great thanks man! May I ask, can this be sent to people via email (outlook) and have other people send it back? I.e. complete! Basically I'm making a list for departments to fill out who is authorised to do XYZ.
@taylorheron5220
5 жыл бұрын
This voice is everything.
@TeachExcel
5 жыл бұрын
haha glad you like my voice ;P
@1gopalakrishnarao
6 жыл бұрын
Thank you. Well explained. Very easy to understand. Waiting for the continuation.
@TeachExcel
6 жыл бұрын
You''re very welcome! Glad you liked it :)
@akakarun8
5 жыл бұрын
This is what I was looking for. I subscribed. Thanks
@jandevries7428
4 жыл бұрын
Excellent detailed video. Thx
@michaeldelarosa7096
6 жыл бұрын
Very nice video tutorial and very well done! Could you tell me how you made your mouse pointer as a yellow highlighted orb? This is very helpful when viewing a demo and I'd like to use something like this internally with our staff here. Thanks....
@TeachExcel
6 жыл бұрын
I use Camtasia for screen recording. It's expensive but works great for this kind of thing, including allowing pointer highlighting.
@CharlesMartel676
5 жыл бұрын
You are an Excel-lent insructor!!!!!!
@TeachExcel
5 жыл бұрын
haha thanks :))
@allabout1135
6 жыл бұрын
Good day Sir, One more awesome video. Thanks. I have question, not related to video above. Can You create video to explain all around chart error bars? I mean usage and meaning in charts, how to insert, tips & tricks. Thanks one more time.
@TeachExcel
6 жыл бұрын
At some point I can, if you remind me, but, at least for the next few weeks, the focus will be on these Excel forms.
@allabout1135
6 жыл бұрын
This forms what You are doing are moast amazing and comprehensive tutorial ever found in KZitem. So clear explained with examples. Thanks for input.
@oneallwyn
4 жыл бұрын
Upvoted just for the title
@TeachExcel
4 жыл бұрын
hahah thanks :)
@graememcgregor8407
6 жыл бұрын
You say you have showed us already how to lift the data and add it to another worksheet. Could you possibly link to that video here? It would make it very complete :)
@TeachExcel
6 жыл бұрын
I know that this exists, hell, I made the damn thing hahah, but I just can't find it in one place right now. In the meantime, here are two of my tutorials, not on KZitem, that will help you do this: www.teachexcel.com/excel-tutorial/1936/copy-and-paste-data-using-macro-vba-in-excel www.teachexcel.com/excel-tutorial/find-the-next-blank-row-with-vba-macros-in-excel_1261.html
@TeachExcel
6 жыл бұрын
BAM! Found it haha! www.teachexcel.com/excel-tutorial/input-form-to-get-data-and-store-it-in-another-tab-in-excel_1570.html This is like the 1.0 version of the thing that I show you how to make in this series of videos, but it does include the macro. In the next series of videos I'll show you how to make a more robust/useful macro to do this.
@Whatsyournarrative
3 жыл бұрын
@@TeachExcel Thank you
@hazemali382
5 жыл бұрын
many thanks MR
@pathirana6964
3 жыл бұрын
Thanks👌👌👌
@aiciled1237
3 жыл бұрын
Also you should read for Audible. The voice would be great.
@abhis4070
4 жыл бұрын
After you hit submit how do I get my data on another sheet in the form of log (like a list with Name ID start date in column A B C D) ?
@tomlehner1317
4 жыл бұрын
I'd also like to know the answer to this
@recipehacker9752
3 жыл бұрын
That is a crucial question. You are basically saying ‘what the hell does that submit button really do’? Many options. What I might do is create a macro that sets all data into variables. Then set that into the desired location. Alternatively, on the other side, you might place on your log VLookUp calcs to just grab the data. The poster will probably charge you to show you the technique. But I just figured it out by trial and error. Good luck 👍
@chhabiacharya4597
6 жыл бұрын
I was thinking of user form. But anyway, nice tutorial!
@TeachExcel
6 жыл бұрын
I will definitely do a UserForm series in the future, sorry for any confusion.
@nmlowry
6 жыл бұрын
OMG this is excellent!! When is the next one coming!!???!!
@ermelindafurtado1788
4 жыл бұрын
Thank you.
@samuelkodjoe1645
5 жыл бұрын
really cool
@nazmidaud2665
5 жыл бұрын
Thank you
@DiscoveryNewsNow
4 жыл бұрын
Without a way to insert it into the sheet I'm not understanding the point, tbh
Пікірлер: 42