Good evening all.

Does anyone have any bright ideas about replicating the Form.Dirty property from Access in Excel?

I'm creating a workflow tool in Excel that utilises a UserForm to display records that are pulled from an Access database.

Users will be able to amend the record details on the form and submit the changes to update the database.

For info, it has to be in Excel as everyone in my organisation has that and not everyone has Access, even the Runtime version.

It works by importing the results of a query (SQL in VBA) into a table in Excel. The form can then navigate between records using Prev/Next buttons but I don't want the user to be able to move to another record if they've made changes to the current one that haven't been saved/submitted.

Short of a long-winded process using Enter and AfterUpdate events on each TextBox and ComboBox I'm stumped. My knowledge of Class modules is nowhere near up to this if that's even an option.

Any help gratefully received!

Beth.