View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tkw tkw is offline
external usenet poster
 
Posts: 2
Default if a checkbox is checked then...

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