+ Reply to Thread
Results 1 to 4 of 4

Userform - Multiple Criterias (Textbox, Combobox) Return Value in textbox

  1. #1
    Registered User
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    20

    Userform - Multiple Criterias (Textbox, Combobox) Return Value in textbox

    Hi, i'm new to userforms and is struggling to do a matching / vlook up formula. Attached is the spreadsheet. It's only a snapshot of the spreadsheet, as i have lots and lots of code, and the actual line items are over 500 lines, with at least 20 providers, across many months. What the code is meant to do, is allow the user to edit and save any changes in the form, into the sheet INPUT. CODE is where all the naming conventions are saved.

    In the Start Tab of the Userform, I want the user to type in a User ID into a textbox, choose a date (calendar button), and status (combo list), which will make the spreadsheet return the value (Accept Tab in the UserForm) that is in column D (name of company) and/or cboCompany (if status = accepted).

    Could someone please help him how I can go about returning a value into txtCompany and txtPrice (in dollar format) where Unique ID matches what is in txtID, Date matches txtDate, and Status matches (cboStatus).

    Many thanks in advance.

    Note. I have incorporated the calendar code from elsewhere (author noted), and it is not mine.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Userform - Multiple Criterias (Textbox, Combobox) Return Value in textbox

    Please Login or Register  to view this content.

    A separate issue: Your Company combobox was misnamed cmdCompany.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    07-23-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Userform - Multiple Criterias (Textbox, Combobox) Return Value in textbox

    You're amazing! Thanks, this works like a charm! Thanks for picking up the typo as well, I fixed it.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Userform - Multiple Criterias (Textbox, Combobox) Return Value in textbox

    You're welcome. Thanks for the feedback.

+ 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. Replies: 0
    Last Post: 08-18-2015, 04:13 PM
  2. Userform Macro need minor adjustments to code (Populate Textbox and Combobox Return Issue)
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2014, 08:07 AM
  3. [SOLVED] Pass Value of combobox selected in Userform as input to textbox of other userform
    By Pradeepg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-29-2013, 10:32 AM
  4. input the value of a Combobox and a textbox to a TEXTBOX directly from a userform
    By Gordonhk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 03:25 PM
  5. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  6. Hide TextBox/ComboBox on UserForm
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2010, 02:47 PM

Tags for this Thread

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