whitehawk81
Board Regular
- Joined
- Sep 4, 2016
- Messages
- 66
Hi, I haven't posted here for while. But unfortunately I'm facing an issue with a userform listbox selection change, that exceeds my knowledge.
The goal, I would like to achieve is following:
There is a multicolumn single select listbox, where the selection populates some textboxes based on the selected data.
You can select any row and the fields get updated accordingly, but changing a value in a textbox gets detected and if you click to another list item, you will be prompted if you would like to keep the changes or abandon them.
In case you select to keep the changes, the listbox should be reset to the previously selected item.
No matter, which method I try, the selected item in the listbox will not reset to the previous selection, it remains the currently selected.
The goal, I would like to achieve is following:
There is a multicolumn single select listbox, where the selection populates some textboxes based on the selected data.
You can select any row and the fields get updated accordingly, but changing a value in a textbox gets detected and if you click to another list item, you will be prompted if you would like to keep the changes or abandon them.
In case you select to keep the changes, the listbox should be reset to the previously selected item.
No matter, which method I try, the selected item in the listbox will not reset to the previous selection, it remains the currently selected.
and iirc the listbox doesn't actually change when you select another row. I remember facing something similar, and will have to look for it. Anyway, good to know it got sorted.
