Need Help On Excel Combo Box

Let me just clarify this:

You want the combo box drop down list to differ, depending upon the value in some cell?

For instance, you might have two lists: one called "ListFor19" and the other called "ListFor7". If the value in the cell is 19, you want list "ListFor19" to appear in the combo box; if the value in the cell is 7, you want list "ListFor7" to appear in the combo box.

Let me know if this is what you want and I think I can show you how to do it! You may also want to consider just using Excel's data validation drop-down list instead of a combo box?

Brian

Thanks for your input Brian. Yes, what I am doing is using another combo box to select a pipe size in a drop down list that returns a value from 1 to 19 depending on the pipe size. I then take this returned index number from the combo box linked cell and use a lookup function to get the actual O.D. of the pipe from another sheet in the workbook.

I now need to select the wall thickness of the selected pipe size by using the index number of the first combo box. I now need another combo box that has the functionality of presenting different sets of data in the drop down menu based on the numerical index value of the first combo box.

The way I currently have the pipe data on the second sheet is index number 1 is in A1, pipe size is in B1, pipe O.D. in C1, pipe schedule D1, and C1 for the associated wall thickness for D1. This continues across the spreadsheet for all the pipe schedules and wall thichness associated with the specific size of pipe defined in B1. The pipe data continues to row 19. J. D. Jackson B.S. M.E. & B.S. E.E.
TransContinental Engineering

JDJACKSON - I think I built a sheet that is EXACTLY what you are doing. Pipe size, wall thickness, etc.

Give me your email address and I will send you my sheet unlocked so that you can see what I did.

My email is: pump@shadow.net Richard Neff
Irrigation Craft

Thanks Richard, jjackson@wt.net J. D. Jackson B.S. M.E. & B.S. E.E.
TransContinental Engineering