Y'all have never let me down. I've looked in the forums and can't find anything specific on this, so here goes:
I have a user form that documents failure modes from a drop down list. When the command button is pressed, I need it to populate ComboBox11 into the first empty cell between F40 and F50.
Unfortunately, I have multiple failure modes to record, some of which will not be populated on execution, so I can't just past the value into a specific cell on the appropriate sheet.
Can anyone help me out on this one?
I have a user form that documents failure modes from a drop down list. When the command button is pressed, I need it to populate ComboBox11 into the first empty cell between F40 and F50.
Unfortunately, I have multiple failure modes to record, some of which will not be populated on execution, so I can't just past the value into a specific cell on the appropriate sheet.
Can anyone help me out on this one?