Feb 22 2024 01:27 PM
I have a Workbook with several Worksheets.
in a worksheet there are seven Comboboxes each with some Vba Code for events Got/Lost focus and Change.
Added another Combo it doesn't work. I'm struggling to understand why
Feb 22 2024 01:36 PM
There are several reasons why the newly added combobox might not be working as expected in your Excel worksheet:
1. Event Code Not Assigned:
2. Enabled Property:
3. Linked Cell:
4. Code Conflicts:
5. Object Model Reference:
Troubleshooting Steps:
Additional Tips:
By following these steps and carefully examining your code, you should be able to identify the reason behind the non-functioning combobox and get it working correctly.
Feb 22 2024 01:48 PM
@smylbugti222gmailcom thank for reply.
I've already checked everything
"Not working" means that I cannot either click on it. When I try to click on it it "moves" some points left and do nothing.
All other Control work fine.
I've also tried to add a couple of simple option-boxes without any code and the result is the same: no interaction allowed
Feb 22 2024 02:06 PM
If you've already checked the common causes mentioned earlier and the combobox still exhibits this unusual behavior, here are some additional things to explore:
1. ActiveX settings:
2. Add-in interference:
3. File format compatibility:
4. Repair Excel installation:
5. Seek professional assistance:
Additional notes:
By exploring these additional possibilities and potentially seeking further assistance, you should hopefully be able to resolve the issue and regain functionality for your comboboxes and other controls in Excel.
Feb 23 2024 04:41 AM
Solution@smylbugti222gmailcom thanks again
I've solved simply deleting and re-adding all the activeX controls of the worksheet (without editing the sheet code module) and everything now works fine.
Feb 23 2024 04:41 AM
Solution@smylbugti222gmailcom thanks again
I've solved simply deleting and re-adding all the activeX controls of the worksheet (without editing the sheet code module) and everything now works fine.