Required Field Entry
Posted by Becky on January 02, 2002 6:41 AM
Is there a way to make the fields on a form in Excel require an entry?
Also, how do you make check boxes mutually exclusive? (only one box can be checked at a time)
Posted by on January 02, 2002 6:59 AM
Re your first question, from Damon yesterday:
12332.html
Re your second question, from Ian today:
12502.html
Posted by Becky on January 02, 2002 7:10 AM
For the first question I think I am looking for something different. I made up a worksheet that we will be sending out to vendors that have questions that require an answer... how do I make those boxes so that they cannot move on to the next question until the questions is answered (even if it's N/A)..
The second question had no answer in the link you sent me.
: Is there a way to make the fields on a form in Excel require an entry?
Posted by Ian Mac on January 02, 2002 7:14 AM
My answer was in the title..."use option buttons...."!!! (NT)
: Re your first question, from Damon yesterday
Posted by Scott on January 02, 2002 7:16 AM
Becky, Are you using user forms for the questions and answers, or are they just on a spreadsheet.
For the second question, the answer was in the subject line of the link (given ealier).
For the first question I think I am looking for something different. I made up a worksheet that we will be sending out to vendors that have questions that require an answer... how do I make those boxes so that they cannot move on to the next question until the questions is answered (even if it's N/A).. : Re your first question, from Damon yesterday
Posted by Becky on January 02, 2002 7:17 AM
Just on a spreadsheet. Becky, Are you using user forms for the questions and answers, or are they just on a spreadsheet. For the second question, the answer was in the subject line of the link (given ealier). : For the first question I think I am looking for something different. I made up a worksheet that we will be sending out to vendors that have questions that require an answer... how do I make those boxes so that they cannot move on to the next question until the questions is answered (even if it's N/A).. : The second question had no answer in the link you sent me. :
Posted by Ian Mac on January 02, 2002 7:30 AM
I can help if you'll answer me some questions?
What exactly do you need from the sheet?
Which check boxes are you using the Controls ones or the Forms one?
(as I said use option buttons, I'd suggest you use the Controls ones as well)
Are the answers Y/N or are they number ranges or somthing else, what I mean is are they consistant thoughout?
Is the form purely visual or do you need to send the results to various cells and calulate after?
If you need to calculate the results I'd look into the idea of use a form using VB.
Does the form need to be used again and again, or just once?
Again if again and again I'd use VB form
Regards,
Ian Mac
Posted by Becky on January 02, 2002 7:35 AM
Answers below : Just on a spreadsheet.
If you need to calculate the results I'd look into the idea of use a form using VB. Does the form need to be used again and again, or just once? Again if again and again I'd use VB form Regards, Ian Mac
Posted by Scott on January 02, 2002 7:48 AM
Becky, Here is some code that might help you get started Copy this to the worksheet project. Change ranges as needed:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("C7") = "" Then
MsgBox ("Must answer question")
Range("c7").Select
Else
If Range("C10") = "" Then
MsgBox ("Must answer question")
Range("c10").Select
End If
End If
End Sub Answers below
