LOOP VBA Microsoft Excel
Private Sub UserForm_Activate() If ActiveSheet.Range(“AK4”).Value = 0 Then CXBTN1.Value = False ElseIf ActiveSheet.Range(“AK4”).Value = “FALSE” Then CXBTN1.Value = False Else CXBTN1.Value = True End If ‘CheckBox If ActiveSheet.Range(“AL4”).Value = 0 Then CXBTN2.Value = False ElseIf ActiveSheet.Range(“AL4”).Value = “FALSE” Then CXBTN2.Value = False Else CXBTN2.Value = True End If End Sub IS THERE A WAY I […]
How do I get my For Next loop to actually loop
I have a loop, however it only finds the first iteration and doesn’t loop onto the next iteration.
VBA: Loop through column values and store
I have constructed a financial model in excel, but want to know the sensitivity of a large set of assumptions. I have a tab of assumptions, which feeds into the model (col D8:D235), in the same sheet, I have made some alterations of these assumptions (Col N : Col R). I basically want to replace the values in col D with the values in each of these columns in a loop, and save the corresponding output values.