Populating combobox from value in another combobox

[tonyp01]

I am trying to populate a combobox (CboMilestones) based on the project number that appears in CboProjNum. I need the values of certain columns to be added to CboMilestones. My spreadsheet is laid out in a paticular order based on a SQL upload that I will have to perform (1st column = project number, 2nd column = milestone 1, 3rd column = must be blank, 4th column = forecasted date, 5th column = actual date, 6th column = Milestone 2, 7th column = blank, 8th = forecasted date, 9th column = actual date....this repeats all the way to milestone 160) I need CboMilestone to populate with all the milestones on the row of selected project number, and then I need TxtADate and TxtFDate to display the dates of the selected milestone for the selected milestone. I am new to VB and I have been pulling my hair out trying to figure this out. PLEASE HELP!!!

Below is a pic of my spreadsheet and a pic of the code i have so far.

Thank you in advance


-- removed inline image ---

 

[Andrew Poulsom]

Welcome to MrExcel.

Instead of trying to attach pictures, just copy your data and macro and paste them into a reply. Please surround your VBA code with code tags.