with worksheets("Somesheetname")
If chkEligable.Value = True Then
.Range("Retirement").value = 0.15 * .Range("Annual_Salary").value
else
.range("Retirement").value = 0
end if
end with

I assumed that both the ranges are on the same sheet (named somesheetname).

And this doesn't check for any non-numerical data, either.

tkw wrote:

I am trying to write a code that will allow me to multiple one range by .15
- IF THE CHECKBOX IS CHECKED - and place the sum in another range. If not
checked then it will equal 0

If chkEligable.Value = True Then

Range ("Retirement") will equal .15 times Range ("Annual_Salary")

Else

Range("Retirement").Value = 0
Thanks

--

Dave Peterson