This is an product order form (simplified for this post). There are 150 lines. In Column A, I have a check box (tick or no tick), in column D I have a fixed Price. In Column E I have set % Disc. If column A is checked I want Column F to show the price less the discount else Blank. I started out entering each line using the controlbox tool by entering a command for each row.
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Range("aa1") = "X"
ElseIf CheckBox = False Then
Range("aa1") = ""
End Sub
After repeating this up to checkbox26 I thought "there must be an easier way". I know very little. I would like to keep the "click of a mouse" option with the checkbox column. Any ideas or suggestion would be appreciated. Thank you
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
Range("aa1") = "X"
ElseIf CheckBox = False Then
Range("aa1") = ""
End Sub
After repeating this up to checkbox26 I thought "there must be an easier way". I know very little. I would like to keep the "click of a mouse" option with the checkbox column. Any ideas or suggestion would be appreciated. Thank you