As a refresher after a long break, this was very clear. You got into the meat of it immediately and within two minutes it was all coming back to me. Thank you. "Show us what you're going to show us, show us, and show us what you've shown us." The basic lesson plan is still the best. I'll be back.
@rcu007
5 жыл бұрын
Oh man! I have used macros to create workbooks for my job, and I spent days copying and pasting more than 1,000s of manual formulas within VBA for a project, and all I had to do was a UDF? It's great to learn new things though! I can see myself doing that project in 10 minutes now. LOL! Thank you very much for these videos!! There are extremely helpful!
@chrismarsden2603
10 ай бұрын
Evening John, Thank you for the video, I found it very useful, informative and most importantly everything seemed to made sense - Thank You
@ExcelCampus
10 ай бұрын
You're welcome, Chris ! 😀
@vladimirmeono
3 жыл бұрын
Great video Jon, it helped me a lot. Thanks for sharing your knowledge.
@JohnOvens
5 жыл бұрын
Thanks, Jon, I have not used UDFs in the past but see that they could help with complex formulas, so will use if future. The video was most helpful.
@mikemoore6151
4 жыл бұрын
You've done an exceptional job with this video. Very clear and concise instruction!
@ExcelCampus
4 жыл бұрын
Glad you liked it 😊
@wayneedmondson1065
5 жыл бұрын
Hi Jon.. thanks for the video on UDFs. I've been experimenting with them and they are very handy. I've created UDFs to extract uniques from a Range, perform math (SUM, COUNT, AVERAGE, etc.) on a range based on the fill color or text color, extract the nth word from a string, etc. The possibilities are endless and there are many videos and blogs to help anyone interested in learning more. It is a bummer that UDFs don't have screen tips.. love to hear your workarounds for that. I've used your example of entering something descriptive in the cell on error. But, that does not help the user keep from making an error in the first place. Thanks again for the insights and Thumbs up!
@heatherr5191
5 жыл бұрын
Thanks Jon, I've been wanting to get into UDFs, going to have to explore this more. As always, a great video!
@ExcelCampus
5 жыл бұрын
Thanks Heather! I appreciate your support! 🙂
@PiyushMedicalKnowledge
3 жыл бұрын
Must watch this video kzitem.info/news/bejne/sWqG1WFoenqqlag This is very important for all of you. This video is about 46 USER DEFINED FUNCTION which will encourage you.
@bjj103
Жыл бұрын
It was probably too basic to mention in the video, but one step skipped over here was how to open the window for writing the function in the first place. So, back after getting access to the Visual Basic screen (Alt+F11), the user needs to choose "Module" from the "Insert" menu. That gives the user a fresh page for writing the function.
@bogdanspineanu
3 жыл бұрын
Thanks !!! Great video!
@sreenivasachamarti1764
8 ай бұрын
Well explained
@cathycordes3957
5 жыл бұрын
Can this function be used to make a due date default to a particular P/N when the PN is entered? I'm trying to set up a function to auto enter a date when I type in a P/N that defaults to 8,20 or 30 days depending on the PN.
@neilmadgwick8394
5 жыл бұрын
Hi Jon. I was intrigued by the IIF statement in the code. When I went into Excel I could not find this function. Is it a function that is only available in VBA?
@ExcelCampus
5 жыл бұрын
Hi Neil, Great question! Yes, the IIF function with two i's is only available in VBA. However, the syntax is the same as the IF function in Excel. I believe the IIF function in VBA has two i's so it is not confused with the IF statement in VBA. I'll do a follow-up video on the differences. The main difference is that IIF is only going to return one result, similar to a formula in Excel. The IF statement has many more uses to run code based on conditions. It also has the ELSE and ELSEIF conditions. I hope that helps. Thanks! 🙂
@ricos1497
5 жыл бұрын
@@ExcelCampus Does it stand for "Inline IF"? Or did I just make that up! For some reason, I rarely utilise the 1/0 for TRUE/FALSE in formulas. For example, your Excel formula could shorten to: =(MONTH(E2)>=10)+YEAR(E2) which I think looks quite nice and still readable. Annoyingly, VBA expresses as -1 for TRUE for some reason and so: FiscalYear = Abs(Month(dDate)>=10)+Year(E2) would be the equivalent, which slightly confuses things because of the additional ABS.
@ExcelCampus
5 жыл бұрын
Hi Rico, Yes, I believe it does stand for Inline If. I'm not sure it's in the official documentation, but have seen it referred to as that. Great point on shortening the formula in Excel. Another option for True is a double negative, like the following. -(Month(dDate) >= 10) + Year(dDate) Always a million ways to solve a problem in Excel... That's what makes it fun! 🙂
@ishitvaishnav9281
4 жыл бұрын
I have addin for number to word for 2007 but not showing automatically I need to press shift f3 to call it pls help
@yulinliu850
5 жыл бұрын
Thanks for sharing!
@apriltrexieigot3747
4 жыл бұрын
Thanks for this video Jon. Can you also help me with as to how I should formulate the function when it comes to tax calculation :)
@PiyushMedicalKnowledge
3 жыл бұрын
Must watch this video kzitem.info/news/bejne/sWqG1WFoenqqlag This is very important for all of you. This video is about 46 USER DEFINED FUNCTION which will encourage you.
@cprogramminglanguagepiyush1891
3 жыл бұрын
@@PiyushMedicalKnowledge I watched your videos it is really helpful
@SyedMuzammilMahasanShahi
5 жыл бұрын
Thanks Jon for the share.
@mahfuzulhaquenayeem8561
5 жыл бұрын
Thanks for the knowledge...
@iniyow
4 жыл бұрын
Thanks, Toby
@scotolivera8207
4 жыл бұрын
What about the tool tip ? Any ideas ?
@stevennye5075
4 жыл бұрын
well done!
@Myclassicalrecording
4 жыл бұрын
Could you create xlookup in xl 2013?
@rdc323
5 жыл бұрын
14:15 is there a way to have the screen tip argument?
Пікірлер: 39