Видео

Yeah I think they may have changed the problem description over the years. In order for all the operations to be O(1) it looks like you'd just need to make sure when you push you're keeping track of the min value in the stack ~ leetcode.com/problems/min-stack/solutions/49010/clean-6ms-java-solution/

What's the job description, what does it entail?

Hey! Without looking at the code for the Macro I'm not sure what the issue would be. But, if you have it working as a "regular" button that points to your VBA code that's a great start. My thought is to make sure that the button on the Ribbon properly points to the VBA subroutine you are trying to execute. I'd give it a shot with a couple smaller examples that maybe just change the color of a cell to make sure your Ribbon works properly 🤔 It's been a while since I've done VBA but hope this helps.

Thanks so much! I appreciate the positive feedback 😁 Mostly work/side projects have been occupying my time. But I would love to get back into making videos soon!

@@maxwelldemaio yep would love to see more problems. Earned a sub. Cheers! :)

Hey there, I did explain how to make an Excel ribbon application. The options link to sub-routines which you can customize for yourself. If you didn't enjoy the video, feel free to find a different one on RUclips.

​@@maxwelldemaioIgnore this guy brother. I love your content. Btw, I know the answer to this is no but is there a git that can help me do this for Mac machines? Thanks

@@theexcelproject6973 When you say Git do you mean a GitHub project? If so, I do have an open-source repository with a bunch of useful macros I have programmed: github.com/maxdemaio/vb-add

I think in VS-Code you should be able to debug any standalone JavaScript file! As long as you set break points, you'll be able to analyze the call stack and local/global variables 😁

The way the array gets into the hash table / object / dictionary (whatever you'd like to call it by) is on line 10. We set a key equal to the current item in the array during the for loop and the value to 1. If we ever find a key (item in the array) we've seen already (present in the hash table), we return true. It doesn't matter what the value is bc we're just indexing on keys so I just put the value to 1 😁

in line number 10 why you adding 1 in the end @@maxwelldemaio

If yes, could you please share the steps or share a video of that too.

Hey! Yes you can use it on different computers. You could move the xla file across devices as needed 😁 Basically once the file has been moved, I'd repeat the steps shown here to get it to work!

@@maxwelldemaio Thanks, it was very helpful.

This is post incrementing, so after the character at index i is fetched, it will increase i by 1. This is so it iterates over all characters!

@@maxwelldemaio ok i think i get it, so you are actually getting charAt(i), and after that you icnrement i++? didnt know it was possible to do it like that in the same statement

@@Satenc0 Yes that's correct!!

@@maxwelldemaio yess it was nice explanation, was only able to understand the solution with your code, would be nice if you make a video explaining also exercise #10 on leetcode, struggling alot on that one, and the explanations i find, cant really understand

To my knowledge there isn't a way to do so. You can export your ribbon from the PC that has the add-in. However, within that exported file will be hardcoded filepaths to the Macros on that PC (you can check by opening it in a text-editor). You can import the exportedUI file to your new PC, but none of the buttons will work because they will be pointing to incorrect filepaths. You can always move your macros onto the new PC, and just take a little time to remake the ribbon.

Good question, that one I'm not sure of. However, what I think would be better is if you only want certain subroutines for a workbook, you should save it as a .XLSM file (macro-enabled). This way you can go into the coding environment, code your subroutines, and actually keep them saved for the next time you open the workbook!

Hi, Tim! To my knowledge, I know you change change the icons of your subroutines by going to the "Customize the Ribbon" setting. As far as drop downs go, that would actually be a type of form the user would interact with. What I've done in the past is displaying a Userform to the user to interact and upon submission the subroutine will execute with the selected parameters!

If you'd like an example of capturing user input, checkout my VBA ribbon application I created called "vb-add" and particularly the subroutine called "rowSpecifyClean" in "Module1.bas" here: github.com/maxwelldemaio/vb-add

@@maxwelldemaio Thank you so much. I appreciate it.

Great video <3 ;

How do I add/link the custom ribbon settings inside the xla file in a global manner, as if its built into the xla file, not referencing it locally or by having to import those settings separately? I want to be able to share my add-in file to a coworker with the custom ribbon and when they enable it in their add-ins, the custom ribbon will appear automatically, as if its a part of the add-in itself. Thank you

​@@tylerharper819I was also hoping to do this, any idea how?

Thank you!

Promise it's not as bad as it seems! 😁