Explanation of Functions, Private Subs, and Public Subs in Excel VBA

[@RickyGunawan95]

wow, have been struggling to understand how function and sub connect together. You explained it really well, thanks!

[@samhayson7777]

Is there a way to share or access Excel names as variables in VBA without passing them? For example using the "Offices" as the name for the number of offices and have VBA access it somehow in memory?

[@EverydayVBAExcelTraining]

It can be done, but it is tricky. A little-known fact is that the personal workbook is just like all other spreadsheets. It just isn't visible. So you can write to the personal spreadsheet or any other spreadsheet for that matter. You will need to save it after you make a change.

[@fatema2024]

How do I combine private subs. I am trying to link the filter of a pivot table to a cell. Then repeat this for 3 pivot tables each has a filter that is linked to a cell

[@EverydayVBAExcelTraining]

I think you would do this as a public sub then call all the macros. Private subs can't be called

[@magicassassin1947]

Thank you so much😍

[@j.fabricioelias227]

Thank you!

[@EverydayVBAExcelTraining]

Glad it helped

[@kingscamilo]

Public and Private are of course not the same...

[@rinkeshverma2880]

You literally can't explain😅

[@EverydayVBAExcelTraining]

Maybe if you send me a message I can explain it here