value of textboxes depends on combined values of 3 combobox in excel 2007 userform

Hi all,

I would like to seek some help regarding my problem..I have a userform that contains 3 comboboxes and 4 textboxes.
What i want for my userform is when i select values from the 3 comboboxes, the 4 textboxes would be automatically filled up with their corresponding values.

the sheet where the vales would come from contains 7 columns.. the first 3 columns contains the values for the 3 comboboxes respectively.
the remaining 4 values contains the values corresponding to the combination of the first 3 column..

i want to know how to do this..kindly help..

There is no userform on this workbook

Try This Example.

I have built some error checking into it for you.

The loops for filling the comboboxes and text boxes are a bit of an over kill for this userform.
They are there to show you how you can build bigger and more complicated userforms.

Please Login or Register  to view this content.

Different method.

Please Login or Register  to view this content.

hi mehmetcik, jindon,

its working! thanks for the quick reply..ill study your advices and hopefully someday i can also contribute to others here.. thank you so much! your the best! this site is the best!

Ryan