Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Required fields
Hell
In Col E I have equipment list, in Col F I have equipment status with data validation, and in Col G I have status explanation. For select equipment status ie., x,y, or z ....I would like the explanation to be required. E.g., Once I enter status X, pop up displays "Please enter a valid explanation" How do I accomplish this Thank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Required fields
Right click on the sheet tab and select view code. Paste in code like this:
Private Sub Worksheet_Change(ByVal Target As Range) if Target.count 1 then exit sub if Target.column = 5 then if isempty(cells(target.row,6)) then msgbox "Please enter an explanation" end if End if End Sub this will work in xl2000 and later. In Excel 97, it will only work if the source list for your data validation is entered in the list textbox -- Regards, Tom Ogilvy "Lupe" wrote in message ... Hello In Col E I have equipment list, in Col F I have equipment status with data validation, and in Col G I have status explanation. For select equipment status ie., x,y, or z ....I would like the explanation to be required. E.g., Once I enter status X, pop up displays "Please enter a valid explanation" How do I accomplish this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Required fields in Excel | New Users to Excel | |||
how to have fields to be required | Excel Worksheet Functions | |||
Required fields with comments | Excel Worksheet Functions | |||
highlighting required fields | Excel Worksheet Functions | |||
Required fields | Excel Discussion (Misc queries) |