Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel and Visual Basic
On Dec 7, 1:00*pm, Deb wrote:
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel and Visual Basic
On Dec 7, 1:45*pm, Don Guillett wrote:
On Dec 7, 1:00*pm, Deb wrote: 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 * * * 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual BASIC in Excel | Excel Worksheet Functions | |||
Visual BASIC in Excel | Excel Worksheet Functions | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
visual basic in excel - | Excel Discussion (Misc queries) |