Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Validation (2000)

    I want to link two cells with data validation such that when I select an item in the first cell from the drop-down choices, the choices in the second cell will be changed to be specific to the first choice. For example, I want to select a nursing unit in the first cell and then have the second cell (via validation) only show the rooms on that nursing unit. Is it possible via VBA or other methods to change the validation data list contents on the fly?

    Thanks!

    Larry

  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: Data Validation (2000)

    Check out Data Validation -- Dependent Lists from MS MVP Debra Dagliesh for an example.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Validation (2000)

    Steve - this is exactly what I was looking for - thanks for your help!

    Larry

Posting Permissions

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