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 ---
Below is a pic of my spreadsheet and a pic of the code i have so far.
Thank you in advance
-- removed inline image ---