Update record - how to pass variable from one userform module to another

I do this very thing all the time in Userforms. I declare a PUBLIC long variable called CurrRow and store the row number that was is currently being used in the form. I use that value to update my DB sheets in when textboxes are changed on my form and an "UPDATE" button is selected. It is far from sloppy, it is quite surgical.

When the UPDATE is done and values are written back to the sheet, the form is cleared and the CurrRow value is cleared as well.

Perhaps by sloppy you meant "a mistake on how the variable is used can lead to errors on the database". Yes, but that of course is true of all variables and of all forms that write to worksheet dbs, you have to get it right.