Excel and Visual Basic

[Deb]

I was wondering if its possilbe to insert a action using visual basic
if a condition is not meet.

Column B4 (Degree)
1. Doctor of Business Administration
2. Master of Arts

Column C4 (Major)
1. Business Administration
2. Master of Arts

I would like to see Column C4 (Major) to read
1.
2. Master of Arts.

I would like to restirct the end user from entering anything in Column
C4 if Degree is equal to Doctor of Business Administration.

Thank you for your assistance

 

[Don Guillett]

I was wondering if its possilbe to insert a action using visual basic
if a condition is not meet.

Column B4 (Degree)
1. Doctor of Business Administration
2. Master of Arts

Column C4 (Major)
1. Business Administration
2. Master of Arts

I would like to see  Column C4 (Major) to read
1.
2. Master of Arts.

I would like to restirct the end user from entering anything in Column
C4 if Degree is equal to Doctor of Business Administration.

Thank you for your assistance

Hard to figure exactly what you want.

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com

 

[Don Guillett]

Hard to figure exactly  what you want.

Send your file with a complete explanation and before/after examples
to dguillett1        @gmail.com

Private Sub Worksheet_Change(ByVal Target As Range)If Target.Count > 1
Or Target.Column <> 4 Then Exit SubIf Target.Offset(, -1) = "Doctor of
Business Administration" Then Target = ""
End Sub