+ Reply to Thread
Results 1 to 5 of 5

Address Book

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Address Book

    New to VBA, so here we go. I want to make address book with userform,is it possible with my example?

    Thank You
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Address Book

    This is dead easy,

    Do you want to investigate it for yourself or do you want it on a plate?

    This is a minor subset of a userform that I am working on so all the code and techniques are there for you to see.

    I will let you see it. See if you can understand it. Come back if you need help,
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-22-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Address Book

    Thank you for the example,but its far over my head at this time. I was hoping for help on this to study and learn code work. Not sure this can be done,all suggestions are welcome.
    Mongoose1

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Address Book

    I hoped that you would play with it and let me know which bits are relevent to you.

    So instead lets get you started on a simple solution.
    Ill look at your data and create something simple to get you started.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Address Book

    Hi

    Took longer than I expected due to an undocumented feature in excel.

    As a test:

    Type "Jo" into the surname box two names will come up.

    Type "B" into the name box

    One name will be listed.

    Click on that name. [ Hmm do you need to click? ]. BRB.

    Code modified no click required if one name listed.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 08-24-2013 at 07:51 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Address book
    By zplugger in forum Excel General
    Replies: 13
    Last Post: 11-28-2011, 10:09 AM
  2. Address Book
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2009, 02:34 PM
  3. [SOLVED] Address Book
    By Saxman in forum Excel General
    Replies: 1
    Last Post: 09-27-2005, 01:05 PM
  4. .xls to OE address book
    By frankg in forum Excel General
    Replies: 4
    Last Post: 07-05-2005, 04:05 PM
  5. Replies: 2
    Last Post: 02-22-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1