Results 1 to 3 of 3

Thread: removing from lookup list records that are selected
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2018
    Posts
    267
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default removing from lookup list records that are selected

    by using data validation we can lookup from a list and select a record.
    my query is how can we delete that chosen record from the list as soon as it is selected?
    it's like a cut and copy paste process but only it is in a drop down list via data validation.
    hope this is clear.
    many thanks

  2. #2
    Board Regular
    Join Date
    Oct 2011
    Posts
    4,255
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default Re: removing from lookup list records that are selected


  3. #3
    Board Regular
    Join Date
    Mar 2018
    Posts
    267
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: removing from lookup list records that are selected

    Quote Originally Posted by AhoyNC View Post
    Thank you very very much..

    is there a VBA for this?
    many thanks
    Last edited by LFKim2018; Oct 2nd, 2018 at 09:56 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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