I have commandbutton1 on a worksheet that launches a userform and initializes all fields to blanks. After entering information to comboboxes, textboxes, etc. an OKButton sends all that information to the next empty row in my worksheet.

I have a commandbutton2 that appears when you click on one of the rows of information created by the userform. I want this button to be an "edit" button of sorts. So, when clicked, the userform reappears but this time is initialized to the information in the row. Then when the OKButton is clicked, it doesn't search for the next empty row, but instead replaces the row that is trying to be altered.

How can I do this? Its like I need to separate initialize functions and two separate OKButton click functions... I don't need help with any syntax or anything just the methodology.

Thanks in advance for the help,