Returning a value if a check box is click to return a value from another worksheet
Posted by Kurt on July 24, 2000 6:19 AM
I hope you had a good weekend. Help again please!!!
I think I am close, but here is the code I have so far:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
If TextBox7 = "SHAMPOO CONDITIONER" Then
TextBox2_Change = Worksheets("Year 1").Range("Y9")
I am trying to return the value of 70% into the textbox2
from a worksheet called year1 in range Y9. I think I am
close, but I am still having problems.
I am sure you will know the fix.