Create a loop and stop executing when it encounters the first blank cell
We have a workbook where data from completed invoices is copied into column C of Sheet1 every month.
Column A is for the Year and Column B is for the financial period (we run 13 periods per year)
Excel VBA CheckBox1_Click() Looping
The below code goes into an endless loop if you click on checkbox1. Any idea why? If I step through the code, it alternatively jumps through each of the two TextBox1.value=… statements. It does not visibly update the check box.