RetireSoon
New Member
- Joined
- Jul 17, 2024
- Messages
- 1
- Office Version
- 2011
- Platform
- Windows
Have application where I am using a ComboBox with the value linked to a cell. The last value selected from the ComboBox is displayed in the ComboBox. If the user manually changes the value of the linked cell to a new value associated with the ComboBox, I would like the user to be able to click on the same ComboBox value currently displayed to "re-update" the linked cell. Currently when I do this, the linked cell will not update. If I select a different value from the ComboBox, the linked cell updates properly. I have tried using the _Click() and _OnFocus() functions but have not been successful in getting the linked cell to update when selecting the current displayed value of the ComboBox. In some situations, I need to allow the user to manually enter a unique value not in the ComboBox. Just trying to make it more user-friendly so that they can easily go back and re-select the displayed value rather than first selecting another item in the list and then selecting the previous item.