Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Validation + AutoComplete (2000)

    I'd like to use Data Validation on a template I'm building to select a supplier from a list
    (held in another spreadsheet). But I'd also like the name to AutoComplete, but this isn't
    there as standard. Can I duplicate this effect via VBA? I couldn't find an event that allowed
    me to run code after each keypress in a particular cell, let alone the ability to select the
    text I add after the cursor so it is replaced by the next keypress.

    Mark

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Validation + AutoComplete (2000)

    If there is just one or a few cells you need to choose from a list, I'd consider using a listbox from the control toolbox tied to the cell underneath it..
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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