+ Reply to Thread
Results 1 to 9 of 9

Get invoice numbers of selected client in invoice combobox

  1. #1
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Get invoice numbers of selected client in invoice combobox

    i have attached a sample file below what i want is when i exit the client combobox of userform1 , my invoice combobox should get populated based on selection in client combobox. ALSO I WAS JUST CURIOUS IF SOMEHOW WE COULD USE TOGGLE BUTTON TO MOVE UP AND DOWN OF INVOICE BOX VALUES (NOT NECESSARILY A TOGGLE BUTTON EVEN ARROW KEY DOWN AND UP WILL DO) AND USE THE INVOICEBOX CHANGE EVENT TO GET THE REST OF VALUES OF THAT PARTICULAR INVOICE Basically i want to filter out invoice numbers of selected client without using filter
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Get invoice numbers of selected client in invoice combobox

    This solves first part...
    Please Login or Register  to view this content.
    Not sure what you mean when saying...
    ALSO I WAS JUST CURIOUS
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: Get invoice numbers of selected client in invoice combobox

    Quote Originally Posted by sintek View Post
    This solves first part...
    Please Login or Register  to view this content.
    Not sure what you mean when saying...
    HELLO ,
    I TRIED USING YOUR CODE BUT IT GIVES MISMATCH ERROR
    I HAVE ATTACHED A SCREENSHOT OF THE ERROR . ALSO I WOULD LIKE TO TELL YOU THAT VALUES IN REC1 (CLIENT COMBOBOX) ARE POPULATED USING THE CODE YOU PROVIDED ME IN MY PREVIOUS THREAD
    Please Login or Register  to view this content.
    SO I JUST WANT A CODE THAT WILL LOOK FOR MATCHING VALUES OF REC1 IN COLUMN B AND NOT IN COLUMN A ..IF THE VALUE MATCHES GIVE CORRESPONDING VALUE IN COLUMN C
    COMING TO TOGGLE BUTTON I GUESS WE CAN SKIP IT FOR NOW
    Last edited by Khanzaki; 05-05-2022 at 07:30 AM.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Get invoice numbers of selected client in invoice combobox

    No need to quote entire posts...It just clutters the thread...Images mean nothing...Upload said sample containing your code...
    ALSO I WOULD LIKE TO TELL YOU THAT VALUES IN REC1 (CLIENT COMBOBOX) ARE POPULATED USING THE CODE YOU PROVIDED ME IN MY PREVIOUS THREAD
    This method does not exclude duplicates....

    Here is your file with my code...Forgot to Clear Dict...Have amended
    Attached Files Attached Files
    Last edited by sintek; 05-05-2022 at 06:38 AM.

  5. #5
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: Get invoice numbers of selected client in invoice combobox

    the new code is working perfect and almost exactly what I WANTED ..JUST A SMALL AMENDMENT
    This method does not exclude duplicates....
    CAN WE STILL USE THAT CODE WHICH DOESNT EXCLUDES DUPLICATES (REASON : I HAVE A MASTERSHEET OF ALL MY CLIENTS IN ANOTHER SHEET ,THIS LIST IS SORTED AND IS UNIQUE , WHENEVER I INITIALIZE THIS USERFORM REC1 GETS POPULATED FROM THIS MASTERLIST , BASICALLY I DONT WANT TO DISTURB THE SOURCE OF REC1 WANT TO KEEP IT WITH THE PREVIOUS CODE ITSELF)
    IS THIS ACHIEVABLE ? OR DO I HAVE TO EDIT MY DATA ACCORDING TO THIS CODE ITSELF
    Attached Files Attached Files

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Get invoice numbers of selected client in invoice combobox

    No need to use CAPS...This depicts "SHOUTING" on this forum lol
    Code updated in file...
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: Get invoice numbers of selected client in invoice combobox

    lol :D not even in my dreams i would ever even think of "shouting" on you genius or anyone on this forum.. i was not aware of it..will keep it in my mind henceforth , thankyou for the code its working like i want to will update you once i compile things here

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: Get invoice numbers of selected client in invoice combobox

    Glad to have helped...Happy Coding...

  9. #9
    Forum Contributor
    Join Date
    10-10-2012
    Location
    Mumbai,India
    MS-Off Ver
    Microsoft Excel 2007
    Posts
    104

    Re: Get invoice numbers of selected client in invoice combobox

    the code is working like a charm just cant thankyou enough mate !

+ 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. Generate list of invoice dates based on start date and invoice frequency
    By yasmin89 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-14-2020, 02:31 PM
  2. Choose Invoice Number from a userform combobox and copy data to invoice output
    By djemy1975* in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2016, 06:02 AM
  3. Print Invoice by pulling info from database by selecting Invoice Number
    By Swapnil Panchal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 11:21 AM
  4. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  5. Replies: 2
    Last Post: 08-28-2012, 05:55 AM
  6. [SOLVED] Extracting data from a client worksheet to create an invoice
    By Jacques E. Bouchard in forum Excel General
    Replies: 1
    Last Post: 05-08-2005, 03: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