Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Check/Tick box's and Mandatory cells
I have 2 questions;
1. I have added check box's e.g Yes No onto a spreadsheet but you can tick both of these. What i am after is to only be able to tick one or the other but not both. Can anyone help? 2. I need to make some parts of my spreadsheet mandatory but i have no idea on how to do this??? I been through the help files but can not find anything about this. Help on this would be great. Thanks |
#2
|
|||
|
|||
hi,
you will need to use this code. right click each check box and click view code. but this sub behind check box 1 Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False End If End Sub put this code behind check box 2 Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False End If End Sub regards -----Original Message----- I have 2 questions; 1. I have added check box's e.g Yes No onto a spreadsheet but you can tick both of these. What i am after is to only be able to tick one or the other but not both. Can anyone help? 2. I need to make some parts of my spreadsheet mandatory but i have no idea on how to do this??? I been through the help files but can not find anything about this. Help on this would be great. Thanks . |
#3
|
|||
|
|||
hi again
forgot about part 2. opps. I know how to hassel a used with a form in access but i'm not that up to excel forms. i have played with them but just play. I personally know of no way to make user input mandatory on a spreadsheet. sorry. -----Original Message----- hi, you will need to use this code. right click each check box and click view code. but this sub behind check box 1 Private Sub CheckBox1_Click() If CheckBox1 = True Then CheckBox2 = False End If End Sub put this code behind check box 2 Private Sub CheckBox2_Click() If CheckBox2 = True Then CheckBox1 = False End If End Sub regards -----Original Message----- I have 2 questions; 1. I have added check box's e.g Yes No onto a spreadsheet but you can tick both of these. What i am after is to only be able to tick one or the other but not both. Can anyone help? 2. I need to make some parts of my spreadsheet mandatory but i have no idea on how to do this??? I been through the help files but can not find anything about this. Help on this would be great. Thanks . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|