User Profile
EMBBerwyn
Copper Contributor
Joined Mar 17, 2022
User Widgets
Recent Discussions
Resetting data validation questions to the default of blank.
I'm creating a health questionnaire for students some of whom are veterans. I've created a little form to help identify their health insurance coverage and next of kin. A copy of which has been uploaded. The questionnaire starts with the query "Do you have health/medical insurance?" If the answer is "Yes", a series of questions will be displayed. For each question there is a data validation list of possible answers. Other than Medicare answers are either "Yes" or "No." Frequently, students and many others are unsure of their health insurance. They may answer incorrectly and later wish to correct their answers. For example, a veteran may believe that Tricare is their primary health insurance. However, by law Tricare only covers approved medical claims after all other insurance claims have been paid. Hence, they may wish to change their answer to the question "Is Tricare your primary health insurance?" from "Yes" to "No'." However, some students start over with the first question, "Do you have health/medical insurance?" In that event all the data validation questions must return to the default answer which is a blank. I have written some code that hides all the questions and returns the answers to all questions to the default blank when the answer to the first question is changed to "No." However, if they change their minds and click on "Yes" or "-" after selecting "No", all their previous answers appear in the data validation cells. I need to reset all data validation cells to blank if they change their answer to the first question. I've tried a couple different Sub routines but when executed they were "$#^^^&^" I've uploaded a workbook "Student Health Insurance." Any suggestions would be deeply appreciated.Solved1.6KViews0likes2CommentsRe: 2 Data Validation Queries and Students Changing Their Minds
Hans, I've run into a problem, students are answering "Yes" to both questions and then changing their major while leaving the Money & Banking answer as "Yes," since seats are limited how can I hide both the second question and the data validation box if or when they change their majors? Thanks,1.1KViews0likes1CommentRe: 2 Data Validation Queries and Students Changing Their Minds
Perfect, I learned that you could insert VBA code directly into the worksheet. I was always inserting VBA code in Module#. Hans, first let me thank you using some of your time to solve my problem. I appreciate the prompt response. Time is our only asset.1.2KViews0likes0Comments2 Data Validation Queries and Students Changing Their Minds
I have a two cells using data validation. A1 Question “Are you an Economics major ?” Data Validation List “Yes/No” A2 Question “Are you enrolled in Money & Banking 203?” Data Validation List “Yes/No” Based upon answers to the above queries different class options are displayed. If a student initially answers “Yes” to both queries and later changes their response to A1 to “No ”, how can I automatically change the response to A2 to “” while leaving the Data Validation list unchanged for A2. A student may change their answer to A1 back to “Yes”, and change their response to A2 from “” to “Yes” or “No”Solved1.2KViews0likes4Comments
Recent Blog Articles
No content to show