Conditional combo box


Well-known Member
Jul 2, 2004
I have a form with 3 combo boxes on it. Customer, Vendor and PO. I have the boxes set up to filter based on the information in the other boxes. Currently I have it set so that based on the vendor only the POs for that Vendor will show up. I also have the customer based on the PO. My problem is that now the users want to sort by the Customer independent of the Vendor or PO. The way I set this up is to build a query for the row source based on a value in the combo box. I then have an event set for on change to requery the next combo box.

What I want to do is have the Customer combo box come up with all customers initially and only requery if the PO is entered. Is there some event that I am missing and can I load values initially and then change them once a value is entered in the PO?

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"


MrExcel MVP
Aug 5, 2003
There's no hidden event that lets you uncouple the second combo; you need to change the rowsource in code. Here is an example.



Well-known Member
Jul 2, 2004
Thanks Sydney. That is what I ended up doing. I have the if statement to check for the value in the combo boxes and if they are both either null or blank(someone may have deleted the value) then I list all records otherwise I select based on one or both of the combo boxes.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...