Thread: check boxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gall gall is offline
external usenet poster
 
Posts: 10
Default check boxes

Ok, my programming is a little rusty.

This is what I need to happen:

I have a worsheet that contains 2 checkboxes.

First..when I open the file I would like checkbox1 to have a check in it and
none in checkbox2.

If the user clicks on checkbox2, I would like to remove the check from
checkbox1. I also would like the cell c43 to contain the value from
worksheet2, cell h24.

If the user then clicks on checkbox1, I would like the check removed from
checkbox2 and the value in c44 to contain the value from worksheet2, cell i24.

If anyone can help, that would be great!
Tricia gall