Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
intersect and combo box
I have a sheet ("Coding"). It has Cost Center numerical
codes running down column A, and Function Code numerical codes running across row 1. In the intersecting cell either the words yes or no appears. "Yes" if this is an appropriate combination or "No" if it is not. A userform is initiated and the employee selects a Cost Center Code from a drop down Combo box. I need a code that will then find that numeric code in the sheet "Coding A:A" and will then populate Function Code Combo box selections with only the Function Codes that can be appropriately used. The code needs to look across the cooesponding row and then insert the approriate Column header for any cell that is labeled "Yes" for that Cost Center. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Intersect operations | Excel Worksheet Functions | |||
Dont intersect | Excel Programming | |||
Intersect Formula??? | Excel Programming | |||
Intersect Formula VBA Help | Excel Programming | |||
Help with If Not Intersect | Excel Programming |