![]() These values essentailly describe attributes of the combobox2 selection value. The 4th, 5th and 6th columns contain data that are in the same row as the value resulting from combobox2 selection. To explain, I have a table for vegetation data which has 6 columns: The first column is a category list, from which combobox1 sources its values, second and third columns contain details, with dependant combobox2 sourcing from this I now have another question which follows on from the dependant combobox in a userform question: I want to autofill fill 3 textboxes on the userform based on the results of the dependantĬombobox (combobox2). Hopefully enough comments to get you started.Įd Ferrero In an Excel form, insert two ComboBoxes, cb1 and cb2.Įd Ferrero Hi Ed, thanks for your help - it's been very much appreciated. ![]() ' dimension arrFilter to the number of filtered values In Details, column 1 has Category values (say Fruit, Vegetables) and column 2 has child values (say Apple, Pear, Celery, Beans, Bananas).Īdd the following code to the UserForm Option Explicit In Sheet1, define the range name Category with a single column, and the range name Details with two columns. In an Excel form, insert two ComboBoxes, cb1 and cb2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |