Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

In need of help for making user madatory to fill out row

0

Im doing this excel stuff that I could get any help if possible.

I have a row and column that user will need to answer base on if the other value it true or not.

Example:

In my column D4 have a value of 3.
If my D4 is greater then 0, then user have to answer the follow question in D7 or something.

In my D7, the Question be like "Have You Eat Dinner Yet? Yes/No?

And if my D4 is 0 then user do not need to answer the question.

Thank You for any help.

Answer
Discuss

Discussion

How do you want to make the user answer the question? Or do you just not want them to be able to fill-out later questions if some specific earlier ones are not filled-out? Are you wanting a macro to run to not let the user do anything else in Excel until they fill-out the answer? How exactly do you want all of this to work, because it can be done with data validation and formulas or also VBA and macros?
don (rep: 1989) May 26, '17 at 8:38 am
F6: Acess Denied: Level = 3   /This determine user to answer the following question
                                               /if not equal to 0 then user need to answer question
Following Qustion
F23: Did The Person Enter The PSP? (Y/N):
F24: If Yes, Was The Person Escorted By An Approved Escort? (Y/N):
F25: Approved Escort Name:
F26: If No, Was The Person Removed FromTHe PSP? (Y/N):
F27: If No, Provide Additional Details:
F28: Did The Approved Escort SIgn The Visitor In And Out Of The PSP? (Y/N):

Each Row I have set up data validaiton list for them to chose from. 

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

If Cells(4, 6).Value <> "0" Xor _
    (Cells(23, 6).Value = "Yes") Xor _
    (Cells(23, 6).Value = "No") Then
    MsgBox "Answer The Folowing Question For PSP(Physical Security Perimeter)"
    Cancle = True
    End If

End Sub


This is what I have so far. I want it so that user will need to answer the following question if the Acess Denied: Level value is not equale to 0. Was using macros. Was thinking of using like a loop so it make user need to answer all those questions.

You was talking about using data validation, how do you set that up? or macros is better?
quang4568 May 26, '17 at 9:43 am
That is quite a lot of new info. Please update your question with that. When im back on a pc i can take a look.
don (rep: 1989) May 26, '17 at 11:31 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login