Forum Discussion
How to limit user to enter correct date format values
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.
SergeiBaklan, thanks a lot for the idea. I will try to apply the same logic. Also just want to reconfirm ,
if we can use VBA and office script together which work on both cases if user working in Excel app than VBA will work and in case any user working in Excel online version than office script ?
any guidance if you can provide here as well.
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.