What's the difference between Private Sub and Public Sub

[MichelleCouden1]

I am working in VBA what is the difference in Private Sub and Public Sub??

[KenBuja]

That becomes an issue if code in another module ever needs to refer to that subroutine. A Private sub would be inaccessible by code in that other module, while a Public sub could be referenced by code in that other module.