However the contents of theĤ textboxes seem to be locked into returning the adjacent values for species in the first Area, ie. I can select the area from the CboArea combobox OK, and can select the species from the CboSpecies combobox OK. I pasted your code into my Excel file, however the same problem still exists. TxtComments.Value = CStr(Sheets('MasterList').Range('F' & CboSpecies.ListIndex + 2)) TxtGrid.Value = CStr(Sheets('MasterList').Range('E' & CboSpecies.ListIndex + 2)) TxtCommonName.Value = CStr(Sheets('MasterList').Range('D' & CboSpecies.ListIndex + 2)) TxtFamily.Value = CStr(Sheets('MasterList').Range('C' & CboSpecies.ListIndex + 2)) I have changed you code, copy the following code to check whether it is what you want. TxtComments = Sheets('MasterList').Range('F' & CboSpecies.ListIndex + 2) TxtGrid = Sheets('MasterList').Range('E' & CboSpecies.ListIndex + 2) TxtCommonName = Sheets('MasterList').Range('D' & CboSpecies.ListIndex + 2) TxtFamily = Sheets('MasterList').Range('C' & CboSpecies.ListIndex + 2) The code I use is shown below:ĬboSpecies.ColumnWidths = '0 cm 2 cm' End Sub In combobox1, then a species from combobox2, the textboxes are filled with values as if I have selected Area1, rather than the corresponding ones for the value of combobox2.Ĭan anyone help - I'm sure it must be something simple.

The problem is that the values that are returned in the textboxes are only relevant for the first area in combobox1, ie. I have script which works properly for the 2 comboboxes, and autofills the 4 textboxes. a particular species inĪ particular area).

I want these 4 textboxes to be bound to combobox2, so that when combobox2 is changed, the 4 textboxes are autopopulated with the values corresponding to that record in the database (ie. The 4 textboxes ('Family', 'Common Name', 'Grid' and 'Comments') refer to Columns 3,4,5 &6 of the database and represent attributes forĪ particular species in a articular area. ComboboxĢ is dependant and selects 'Species' from the area selected in combobox1 (Species are in column 2 of the database). The first combobox selects 'Area' from column 1 of the database. The userForm has 2 comboxes and 4 textboxes.

I have a plant database of 3,500 records and an Excel UserForm to select records from this database.

Excel userform combo box two columns