Methinks the code has been tampered with.

If Me.RevisedTotalDropDown throws an error then I can tell that Me doesn't contain a control called RevisedTotalDropDown.



Your subroutine is called Document_Open which implies it runs automatically when a document is opened. I note that this code is not opening a userform.

However, your code includes Me.controlname items which are used inside a UserForm module and the 'Me' refers to the userform itself. I would have expected your userform code to sit inside a macro named UserForm_Initialize and it would then run after the userform has been shown.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia