I’m working on a system on Excel VBA that compiles employee attendance and calculating certain values. I was amending some codes when suddenly my earlier codes for:
“Format(Now(), “Short Date”)” changed to “format(Now(), “Short Date”)”.
Now my earlier codes that format the current date are unable to run properly. Attempts to change the First Letter just reverts back to lowercase and renders the format as a text rather than a function. (This applied to all my codes that ran the format function)
Does anyone have an idea of why my formatting function suddenly changes and is unable to work?