View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb[_5_] Deb[_5_] is offline
external usenet poster
 
Posts: 1
Default Excel and Visual Basic

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