ActiveX Controls / OLEobjects in Excel Worksheet

Piero800 

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:

• Enable ActiveX controls: Ensure that ActiveX controls are enabled in your Excel settings. Go to File > Options > Trust Center > Trust Center Settings > ActiveX Settings. Make sure "Enable all controls" is selected.
• Security restrictions: Check if any security restrictions in your organization's policies might be blocking ActiveX controls. Consult your IT department if necessary.

2. Add-in interference:

• Disable temporary add-ins: Try temporarily disabling any add-ins you have installed in Excel. Go to File > Options > Add-Ins > Manage COM Add-ins. Uncheck any add-ins and restart Excel to see if the issue persists.

3. File format compatibility:

• Save as different format: If you received the workbook from another source, try saving it as a different format like xlsx or xlsm. Sometimes, compatibility issues between different versions of Excel can cause unexpected behavior with controls.

4. Repair Excel installation:

• Office repair tool: As a last resort, consider using the Office repair tool to potentially fix any corrupted files or settings related to Excel. You can find this tool in your Control Panel under "Programs and Features" or "Apps & features" depending on your operating system.

5. Seek professional assistance:

• Advanced troubleshooting: If none of the above solutions work, you might need to consult with an Excel expert or IT professional for further troubleshooting and potential code analysis. They can help identify any underlying issues specific to your situation.

Additional notes:

• The behavior you described where the combobox "moves" slightly when clicked is unusual. It could be indicative of an underlying issue with the control itself or how it interacts with the worksheet.
• Since you mentioned option boxes also exhibit similar behavior, it suggests the issue might be broader than just the comboboxes and could be related to how controls are rendered or interact within your specific Excel environment.

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.