View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree[_2_] scrabtree[_2_] is offline
external usenet poster
 
Posts: 47
Default 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.