Originally Posted by isladogs
Another point might be readability for others.
IMO MyCamelCaseField is easier to read than My_Camel_Case_Field ...but you may disagree.
I personally find the version with underscores easier to read, but I think it may be a matter of personal preference (albeit a weak one).
Originally Posted by Galaxiom
[L]ots of tiny words make terrible object names no matter how they are typed. A couple of SubstantialWords makes a far more readable name. Surely nobody would ever include a preposition (eg 'of') in a name.
The underscore already has a role in VBA separating the procedure name from the object name.
Private Sub SomeControl_AfterUpdate
That was NOT a real world example. strPath_Ext or strFile_Name are more likely examples.
Your point about the role of underscore is well taken.