I am new to VBA and do not know the difference between "Private Sub" and just "Sub" in a macro or where or when to use it, Any quick help please?
I am new to VBA and do not know the difference between "Private Sub" and just "Sub" in a macro or where or when to use it, Any quick help please?
Hi Softman
Save me explaining
If you highlight the Sub or Private sub in a piece of code, then key F1 the microsoft help file will explain all.
Rob
A Sub is Public unless it set as Private. Private Subs are not listed in the macros that can be ran. These are usually set for you when you use an Event for example. Note the Userform code is Private for the objects since they have events. A Class typically has some Private Subs. A module can have a Private Sub if it is used just in that Sub. Most Module code is typically Public.
Many thanks Kenneth, great explanation.