Consulting

Results 1 to 7 of 7

Thread: select data using drop down list

  1. #1
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    155
    Location

    select data using drop down list

    Dear Team,

    I am having data (Name and Email ID) from Sheet 2.

    In sheet 2 names listed on B6:B23 and Email Id listed on C6:C23.

    In Sheet1 "D1" i had created drop down list of names. When i am select name on drop down list on D1 the email is should display on G1.

    For example, I select the name which is on Sheet2 B6, the email id should display from C6. If i selected B9 then email id should display from C9.

    Can any one help to create code for the above condition.

    My file is attached with this mail for reference
    Attached Files Attached Files

  2. #2
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Try:
    Attached Files Attached Files
    Semper in excretia sumus; solum profundum variat.

  3. #3
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    155
    Location
    It is woeking great. Thank you Mr.Paulked.

  4. #4
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    You're welcome
    Semper in excretia sumus; solum profundum variat.

  5. #5
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Please respect this forum and its' members, I won't answer your question in your PM to me. Please see here http://www.vbaexpress.com/forum/faq....aq_req_help_pm for my reasons.

    If you need further help, start a new thread.
    Semper in excretia sumus; solum profundum variat.

  6. #6
    VBAX Contributor
    Joined
    Jun 2019
    Posts
    155
    Location
    Dear Paulked,

    I apologize to send PM message.

    I have one more query.

    When i am selecting the name on the drop down list it is filter the name as per my selection and the email id also displaying.

    I want the filtered values send by outlook email to the email address which is displaying on G1.

    Can you please help me for this

  7. #7
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Ron de Bruin has a great site for email with VBA here https://www.rondebruin.nl/win/s1/outlook/mail.htm
    Semper in excretia sumus; solum profundum variat.

Posting Permissions

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