Forum Discussion
Solved
How to limit user to enter correct date format values
Hi All, I have excel file saved in SharePoint location and multiple users are updating the same. in that file we have 4-5 date columns where I found users are entering sometime incorrect date forma...
For VBA you need macro-enabled workbook which usually a headache in corporate environment. Office Script actually gives nothing, it doesn't work by event. With it you may only check (pressing the button or like) if dates were entered correctly, but in your case that's actually the same as conditional formatting but more complex.
In general yes, you may work online with macro-enabled workbook, the only macros won't work.
"While Excel Online doesn't support data validation as of my knowledge cutoff in September 2021"
It's August 2023 and Excel for web supports Data validation.
That's what happens when you mean things differently and pass other things on. This is what happens when you mostly work with SharePoint Server 2016. Anyway thanks again for the hint :).