View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lisa Ann Kashner Lisa Ann Kashner is offline
external usenet poster
 
Posts: 8
Default check box checked - then a result to show in another cell????

Hello,

I would appreciate any help concerning "check boxes".

This concerns a trucking company.

The company has multiple "runs" in different locations/states. Each "run"
pays a different amount.
I would like to use the "check box" for the person to check off the run
he/she did at the end of the day. Then in turn, I need that $ amount to read
out into an "other cell".

For instance, a "run" to the state of Virginia is $37.50, so when that
"Virginia box" is checked (b7) - how can I get the $37.50 dollar amount out
into cell e7?

Thanks in advance! Lisa Ann Kashner