Loss1003
10-21-2016, 02:00 PM
How can I find the first cell in a column by criteria and then replace that with a userform combobox value.
For instance, let’s say I have a column (D) with the following formula dragged down to each cell.
=IF(C2="MP","Mike P","")
And I wanted the first cell that meets the following criteria: “” in that column to be replaced with a userform combo box value (Player2) after the command button is clicked on.
See attached worksheet.
For instance, let’s say I have a column (D) with the following formula dragged down to each cell.
=IF(C2="MP","Mike P","")
And I wanted the first cell that meets the following criteria: “” in that column to be replaced with a userform combo box value (Player2) after the command button is clicked on.
See attached worksheet.