How to Design and Code an Excel VBA Application Like a Pro

Hi Everyone. I hope you enjoy the video. You can download the code from the link in the video description.

Awesome 👍，Thanks

Thank you, Paul, for this great video. Just one quick question: This example has 2 columns so u using key for company and Dic(key) for the amount. What if we have a 3rd column. How could we name then? Since dictionary has only key and value. How can we call the 3rd column ?

Clean code makes me smile

Hi, i need to create an excel sheet for 3 more schools data maintain . is it possible?

Never thought of saving the Excel settings code as a class module, but that's really efficient and found that really helpful!

Wonderful. Thanks a lot.

I'm a bit confused, watched it through, and i do not see the point for making such complicated tool for as simple task as shown. I get it is capable to to more that it is shown, but in just 30 sec i would complete the given task with out using VBA, just some written out formulas.
+Unique (Company names)
(+Sumifs ) * discount

Why do you prefix code modules with mod when they are clearly under the modules folder in the project explorer?

Thanks 4 ur email.. for now, im trying to change my methods from Array to Collections. I have saw ur Video about Collection. May this method solve my problem on my Active listbox, select list then delete, single or multi. And the listbox can not handle refresh data after numbers entry reached up to 20

Smashing..
You are a gun Paul

Why don't I see the VBAProject (Create Application .xlsm) section in my window?

I just use loads of global variables for everything and a few 9 tier if conditionals and loops . Clicking run is equivalent to throwing a tennis ball into a room full of loaded mouse traps, variables flying everywhere! I'm trying to do better though, this video is helping a lot.

A great video. Will come back to it often for my education. Paul, you are a fantastic teacher.

Thank you again. After years of doing the macro recorder and begging for help on message boards I am finally determined to learn and hopefully (eventually) contribute to the boards. I have a huge macro system and there is an intermittent issue. I am determined to figure it out and a guy at mrExcel shared your link. I’m hooked. Thank you for making these tutorials.

I got totally lost in this learning within the first 15 min. Why do we "call" something? what does "(byval ...as dictionary) as dictionary" do and why do you enter "as dictionary" twice in this statement? I guess i need an even more basic than this tutorial. any recommendations?

Dear Sir I find your style of teaching very interesting and in depth. Therefore I want a PDF copy of your Excel VBA Hand Book, plz advise how much would that cost me. Thanks

“Many junior programmers will create a single sub with hundreds of lines of code”

I feel personally attacked somehow. 😅