I still can't understand why the simplest things are the hardest for me to find. I can find things like list inversion, sorting, Martian characters, ad nauseum, but not anything about how to change the list used to populate a listbox. I have gone through tutorials and tips and found nothing. My brain is so full of esoterica now that I don't know where to start.
I have a userform with Listbox with 15 items that is populated from a Data Validation list on a sheet. I don't have any code for the Listbox, just the listbox property "ControlSource" of the Sheet cells of the Validation List.
The purpose of the Listbox is to allow the users to change the items in the Data Validation List. My thought is that the ControlSource prevents me from changing anything. I use the Data Validation pull down list in 175 places on the spreadsheet.
I want the users to select an item in the Listbox, type over that value, and have that value replace the one in the Data Validation List. I don't want to add to the list, just replace that item.
I don't know if I should populate the Listbox by by using "Additem" in the subform Activate and then some sort of "Case" statement in the "Change" event of the Listbox. How do I identify which item in the Listbox has focus and how to put the changed item the same place into the Data Validation list.
TIA
Heisenberg was probably right.
I have a userform with Listbox with 15 items that is populated from a Data Validation list on a sheet. I don't have any code for the Listbox, just the listbox property "ControlSource" of the Sheet cells of the Validation List.
The purpose of the Listbox is to allow the users to change the items in the Data Validation List. My thought is that the ControlSource prevents me from changing anything. I use the Data Validation pull down list in 175 places on the spreadsheet.
I want the users to select an item in the Listbox, type over that value, and have that value replace the one in the Data Validation List. I don't want to add to the list, just replace that item.
I don't know if I should populate the Listbox by by using "Additem" in the subform Activate and then some sort of "Case" statement in the "Change" event of the Listbox. How do I identify which item in the Listbox has focus and how to put the changed item the same place into the Data Validation list.
TIA
Heisenberg was probably right.