Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Checkin and Dependant Data Validation List (Excel XP)

    XServiceLevel uses data validation - List =ServiceLevel
    XZone uses data validation - List =Indirect(XServiceLevel)

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    I need to force the user to update the XZone cell if they have changed the XServiceLevel entry.

    something like this - =IF(XZone=INDIRECT(XServiceLevel),"","Please choose the correct zone.")

    where XZone=INDIRECT(XServiceLevel) returns a #VALUE error.

    What is the solution?
    Many thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Error Checkin and Dependant Data Validation List (Excel XP)

    You could add the line you proposed (formatted RED and Bold or something)
    =IF(XZone=INDIRECT(XServiceLevel),"","Please choose the correct zone.")
    in the cell NEXT to the item, but it would NOT force them to change it.

    You could also change the cell color using conditional formatting [=XZone<>INDIRECT(XServiceLevel)], but again it would not force the change
    The only way to force it to be done is with a macro. Data validation only works on data entry and does not ensure that the selection remains vaild if something else changes in the workbook.

    Instead of validation you could use comboboxes. and when the "Xservicelevel" combo changes it "resets" the XZone.

    You could even do it with a custom form if there are many of these items to enter. Just do not allow editing in the database, ONLY allow editing from the custom form.
    Steve

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Checkin and Dependant Data Validation List (Excel XP)

    Thank you for the advice. I'll try the combobox. <img src=/S/read.gif border=0 alt=read width=19 height=33>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •