I've got a userform that has a combobox and several text boxes and checkboxes. The combobox presents a list of numbers that represent lines in a table. When a number is selected the text boxes and check boxes are populated with data from that line of the table.

The problem I'm having is sort of an odd one. This user form is supposed to be used to edit a line from the table and when I change information in the userform after it has been pulled from the table the spreadsheet is updating in real time rather than when I click the "Accept" button (which has code to re enter that information in the spreadsheet).