I have a nagging problem that perhaps you can help solve.
in the attached file, when a userform is selected a user is supposed to FIRST select a row in the userform and then enter information that populates a sheet in the background. Often times, a user will start typing without selecting a line first. When this happens, and they save the userform, it clears the headers of the sheet and subsequently the listbox. Is there a way to prevent a user from hitting save unless they have selected a row in the listbox? Or is there a way to prevent an inadvertent save from wiping out the headers?
Thanks in advance