Hi....I have 2 comboboxes on a user form. the first has a list of all 12 months which are listed on a worksheet named "Lists" the next 2 columns of data on that sheet list the dates of the time periods for that month. what i need is for the 2nd combo box to list the pay period dates from the neighboring 2 cells next to the month the user selects

example:
column G..........column H..........Column I
Month...............1st - 15th..........16th - Last day of month

so if the user selects whatever month is listed in cell G5 from combobox1, then combobox2's list should be populated with the values from cells H5 and I5

Similarly I have another user form which has a combobox that pulls its list from the same worksheet with names of locations in column E, and I would like to have a dependent textbox display the address of the location from the neighbor cell in column F

example:
column E..........column F
KMART...............4325 Broadway St, Eureka

I have seen similar examples of this but am not quite sure how to edit the code to match my needs....can someone show me how??? thanks for all the help...this forum has already helped me more than i could have imagined. No rush, just a little personal project...i am patient, thanks again