Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
172
Views
Topic starter
Hello there,
I was wondering if there was a way to code VBA to restore to calculated column formula after I edit data with a userform? I currently have a field which marks a date as being past or upcoming depending on the date in another field. I can update this date using a userform but when I do the calculation to determine if the date has passed or not stops working.
Any help would be greatly appreciated.
cheers,
Posted : 29/07/2022 4:48 am
Hi Matthew,
The userform should not write into the calculated column, it should write instead into an additional column, that must be handled in the calculated column formula.
Posted : 31/07/2022 12:06 am
