MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Hello Randy,

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")
End If
End If
End Sub

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.

Thanks,

Kurt


Posted by Ryan on July 24, 0100 10:31 AM

Kurt,

I guess I will disregard the fact that you forgot my name and called me Randy! :-). Here is your fix I think:

Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
If TextBox7 = "SHAMPOO CONDITIONER" Then
TextBox2.Text = Worksheets("Year 1").Range("Y9")
End If
End If
End Sub

Ryan

Posted by Kurt on July 24, 0100 11:07 AM

Ryan,

Sorry about that I hadn't had enough caffeine :-)

Thanks, I did get it and checked it against your code!

Please forgive me oh Master San!!!

Kurt