dependent comboboxes

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

Originally Posted by Palmetto

You don't need (and shouldn't use) another combobox to display the values of two cells.

Hi Palmetto, thanks for the help, but I don't want to display two values, i want a choice between the 2 values for the dependent combobox. the dependent text box i am doing will display just 1 value...anyway i think that will work for one of the needs i described. will post again after i have tried it out. thanks again, you guys rock

Hi again, so that works perfectly for the dependent text box...thank you thank you!! here is the code i ended up with if your curious

Please Login or Register  to view this content.

you guys are just awesome....I can't figure out how to edit that to fit my other user form however...I need a combo box so the user has a choice between the 2 time periods. Thanks again, you guys rock!!

Originally Posted by Palmetto

Please Login or Register  to view this content.

oh wow you replied while i was typing my last reply, will try this out and get back, thanks!!!!

hi palmetto, this errors out on me...not sure why, except that I don't understand "option explicit" does this code need to go somewhere besides the combobox change event? here is the code i ended up with, what did i do wrong??

Please Login or Register  to view this content.

i put option explicit at the top, but it seemed to end up on the bottom of code i have to format another combobox

here is what is highlighted with the error

Please Login or Register  to view this content.

the error code i get is

"Run-Time Error '1004':

unable to get the Vlookup property of the WorksheetFunction class"

hi....so here is the code again, edited again.....i changed the name of the combo boxes...just in case you notice that difference....still get the same error...there is a sheet6...it is named Lists.

Please Login or Register  to view this content.

I also tried naming the range and changing the code to this

Please Login or Register  to view this content.

Still getting same error.....any idea's??? Thanks again for all the help

the combobox is populated with the rowsource property which is set to (Lists!G2:G13). "Lists" is the name of sheet6....so they have no choice but to match each other....is there any way i could messenger or email it to you?? the workbook size is too large to upload here....if not i will find a place to upload and post a link