Results 1 to 4 of 4

How to Autocomplete Userform from Worksheet info

Threaded View

NoellaW How to Autocomplete Userform... 04-03-2013, 05:21 AM
AndyLitch Re: How to Autocomplete... 04-03-2013, 05:38 AM
NoellaW Re: How to Autocomplete... 04-03-2013, 07:04 AM
AndyLitch Re: How to Autocomplete... 04-03-2013, 07:17 AM
  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    4

    How to Autocomplete Userform from Worksheet info

    Hello:
    Have to admit that I'm being tested to my limits (which are very limited).
    I've created a basic userform, comprising of text boxes and 1 combo box. Text boxes are ID, Partner, Territory and Deal. Combo box is Agreement.
    UserForm.jpg
    I've also added command buttons for Add, Clear Form, Exit and Check.
    When the user enters an ID number - I'd like them to click "Check" which will then search the Worksheet for the ID number, if it exists the UserForm will be auto-completed with the information relating to that ID number. If it's a new ID number, the user completes the form. Needless to say information relating to an ID will always be the same ie: ID 8 will always be Misc/Martin/Lunch/Multi.
    Can anyone help please!
    I've tried running a search but that is honestly as far as my experience will take me and it's incorrect.
    Copy Worksheet attached
    Many thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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