User Form Combo Box Input/Value Source

[jane serky]

Hi all

I have created a user form to create, save, edit and delete records to/from an Excel database. It has 2 combo boxes (combo 1 and combo 2). Combo 2 drop down list is dependent on the selection in combo 1. They both use dynamic named ranges for their lists and allow manual user input as well as selection from the drop down list.

When the form is used to read a record from the database, the 2 combo boxes are populated with the data in the record. I need to set the drop down list in combo 2 based on the value in combo 1 ie - I need to determine if combo 1 value was selected from the drop down list or manual user input. I can't use the index value when the record is first populated, as it it <-1 even if the value was originally selected from the list.

What is the best way to determine if combo 1 value is from the combo list or not?

As I am relatively new to coding, I am hoping for a simple answer

Thanks

[Norie]

If the value isn't on the list then the ListIndex will be -1, the ListIndex can't be less than -1.

[jane serky]

OK - my mistake. The ListIndex = -1. When the record was originally created, if the selection was from the drop down list, ListIndex > -1. The problem seems to be the process of saving it to the database and then re-reading the record; the ListIndex is 'reset' to -1.

[Norie]

Jane

Is this when you are entering a new value in the combobox?

Are you updating the combobox's list after you've added the data to the worksheet?

[jane serky]

Hi Norie

your comment re 'if the value isn't on the list, then the ListIndex will be -1' got me thinking about the relative timing of the code ie - was i populating the combo box value before populating the combo box list? And this was exactly the problem. I changed the code order to set the combo box list first and then set the combo box value. Problem fixed.

Thanks for your tip.