Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Validation list (XP)

    Sheet 2 has the all of the State names. List has been named States. Sheet one has data validation based on this list. Instead of dragging down through the list to find a State to select I would like to be able to type in for example, M, in order to jump down the list to States beginning with M. I am sure I have seen this before using code, but I cannot locate it now. Not sure if it was from the Lounge or some other site. Help would be appreciated.

  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 list (XP)

    DataValidation does not work this way. It can be done using the combobox from the controltoolbox. These are the default settings so all you need do is add the linked cell and listfillrange...

    Steve

Posting Permissions

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