How to adjust codes to require input to desired cells Only?

Hello,

I am very new to VBA and am hoping that people can please help me.

I have a spreadsheet that I need schools to fill out, as shown in the attached Excel file. If a student's Status is "Graduated" (column D), I want require them to fill out the "Career After Graduation" column (column G). The closest codes I could come up with are listed below, and I have two problems here.

1. As shown in the attached image, Excel requires input not only in G2 and G3, but also in other cells. I don't want to require input to other cells, but have no idea how to adjust my codes accordingly.

2. Also as shown in the attached image, the error message lists the cells that need to be filled out twice. How do I have them only listed once?

I don't want use data validation since I need to use this function to add some drop-down menu. If you could please help me with the codes, I'd greatly appreciate it!

Please Login or Register  to view this content.

Try this code

Please Login or Register  to view this content.

@ YasserKhalil

This worked perfect! Thank you thank you so much!!

@YasserKhlil

Thank you again for the codes! I now have an additional question.

I was trying to see if I can apply your codes to different situations. When I changed "Resize(1, 5)) < 5" to different numbers, it worked every time excepted when I changed it to "Resize(1,1)) <1". Instead of giving me a message saying I needed to fill out B2, it says that I need to fill out G2, C2, F2, B3, E3:F3, C4:E4, G4 and G3. Why do you think it let me fill out multiple columns?

Thank you!

If you need to deal with column B only you can change the range ..
Instead of using A2:A20 .. you can use B2:B20 ..
So you don't need to offset or resize in this case

Try the following

Please Login or Register  to view this content.

Thank you!

You're welcome. Glad I can offer some help
Please mark the thread as solved

Hi yl41012,

Along with marking your thread as solved, if it is so, please take moment and look at the forum rules about the use of code tags along with not posting full quotes. It just creates clutter.