Hello everyone. This is my first time posting here.
I have a question I hope someone can help me with. I am somewhat familiar with coding in excel but not a master by any means. I want to create pop-up boxes (windows) in a spread sheet that will pop-up when you click a particular cell. So the clicking inside the cell would act as the call button for the pop-up box. The box would have a series of 3-4 yes or no questions in it. Each question would be scored 1 point if answered correctly. So if the answer is yes you score 1 point, if you answered no, you get no points. It would need to calculate the points of the box and automatically enter the total points in the cell you originally clicked. I know there are probably several ways of doing this. But not sure how. Could someone help me out or point me in the right direction?
I have a question I hope someone can help me with. I am somewhat familiar with coding in excel but not a master by any means. I want to create pop-up boxes (windows) in a spread sheet that will pop-up when you click a particular cell. So the clicking inside the cell would act as the call button for the pop-up box. The box would have a series of 3-4 yes or no questions in it. Each question would be scored 1 point if answered correctly. So if the answer is yes you score 1 point, if you answered no, you get no points. It would need to calculate the points of the box and automatically enter the total points in the cell you originally clicked. I know there are probably several ways of doing this. But not sure how. Could someone help me out or point me in the right direction?