+ Reply to Thread
Results 1 to 7 of 7

Products for specific customer should appear in text boxes when we choose that customer.

  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Products for specific customer should appear in text boxes when we choose that customer.

    Hello

    As my title says, i have a cataloque with customers-the products that they use and their price in sheet 13.

    Same products is possible to use more than 1 customer BUT perhaps with different prices.

    My goal is when i open my userform and choose a customer from a combobox, then the products with their prices for this customer should appear in the text boxes.

    The user will add the quantities(perhaps not at ALL text boxes) and excel will calulate the subtotals for eatch product.

    Thanks in advance for any assistance on this.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Products for specific customer should appear in text boxes when we choose that custome

    I changed the names of the controls to sequential column names.

    I changed the date textbox to a datepicker.

    In the combobox event, it searches for the customer name and when found inserts the values of the corresponding column to the userform.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Products for specific customer should appear in text boxes when we choose that custome

    Thanks for looking my issue. Unfortunately,

    I get this error when i try to open the workbook.

    "Could not found an Object because it is not available on this machine"

    I suspect that is the date picker that you mentioned(which i am not able to see it).

    I don't need the date picker. Can you pls reverse your code without the date picker?

    When i click ok in the above message, i choose a name from combo box and i get this message.

    "Can not find project or library"


    Thank you!

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Products for specific customer should appear in text boxes when we choose that custome

    Just delete the datepicker and add the textbox back. There is no code associated with it.

    I'm not sure on the other error. Which line does the error occur?

  5. #5
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Products for specific customer should appear in text boxes when we choose that custome

    The problem is that i don't see any date picker there. Take a look to the video pls!

    http://screencast.com/t/5s1XSbwk

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Products for specific customer should appear in text boxes when we choose that custome

    The only thing missing is
    Please Login or Register  to view this content.
    The sample sheet you uploaded was corrupt. (The sheet names in the VBE windows were mostly question marks.)

    I had to start anew.

    Do you get the error on my file?

    Same goes for the datepicker. You have to set the reference in the Tools->Reference->Microsoft Datepicker.

    If you're still getting that error, I'd do a cold reboot.

  7. #7
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Products for specific customer should appear in text boxes when we choose that custome

    Quote Originally Posted by Tinbendr View Post
    The only thing missing is
    Please Login or Register  to view this content.
    That's it!

    Thank you!

+ 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. 3000+ Rows of Data - Need to Summarise Customer Products & £ Spent
    By Milo_C in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2013, 11:09 AM
  2. Finding out how many products a customer permanently stocks.
    By Paxman71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 10:15 AM
  3. Top 3 sold products and qyty by customer from list
    By e602043 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2013, 11:01 AM
  4. Searching and displaying multiple products per customer
    By idemdito in forum Excel General
    Replies: 1
    Last Post: 09-13-2011, 08:38 AM
  5. Choose customer; only show non-blank boxes
    By LaurenSmalley in forum Excel General
    Replies: 12
    Last Post: 02-03-2011, 03:19 PM

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