lundi 29 décembre 2014

Matching ranges with a checkbox

I think this is simple but I'm new to VBA. I have a row that I would like to be either 0 or a value from a different row (matching length and position). I have a computed financial statement line that I would like to bring into a different financial statement or null depending on a checkbox. Here is what I have so far but it just returns E111 for the entire range, I would like E60=E111, F60=F111, etc.


Private Sub CheckBox2_Click() With Worksheets("Project Model").Range("E60:KX60") If CheckBox2.Value = True Then .Value = 0 `If CheckBox2.Value = False Then .Value = ("E111) End With End Sub


Anyone know a quick fix?


Thanks!!





Aucun commentaire:

Enregistrer un commentaire