Excel ComboBox (ActiveX Controls) dropdown not functioning
Hello all, My issue occurs when trying to select the dropdowns for ComboBoxes on this Excel sheet. Everyone else in my department can access and use this sheet without issue. However, when I select any of the ComboBoxes, right-click and left-click cause a phantom dropdown to hover in the cells above the ComboBox without actually opening the dropdown: I discovered that I can edit the selection from the dropdown if I go to Developer tab > Design Mode > Right-click ComboBox > ComboBox Options > Edit: This is an un-optimized, time-consuming solution (to say the least) when I should be able to make these same selections by simply left-clicking the dropdowns when not in Design Mode. I'm guessing that this is an issue with some unknown Excel setting since the ComboBoxes only misbehave this way on my laptop across our office. The sheet is unprotected and creating new ActiveX ComboBoxes results in the same dropdown selection issue. Any help this forum can provide will be greatly appreciated!!
ActiveX 'button' has stopped working
My PC has rebooted itself three times today (13th June 2019) through automatic updating. I do not know why but the ActiveX 'button' in one of my key workbooks has now ceased to work. I used an ActiveX 'button' because I wanted better control over its background colour, which a basic form button does not allow for. I have a workbook with multiple worksheets. Near the 'end' of the workbook is a statistical sheet, which also serves as a clickable table of contents. Those table of contents functionalities have not been corrupted. On each of the main worksheets there is an ActiveX 'button', which is named CommandButton1 (the name the system gave it when I first created it about 15 days ago). On examining it in Design Mode, it appears to still be an ActiveX 'button' with its text and colour formatted correctly and the code view is what I expected (see below) BUT the button has just simply ceased to work. ThisWorkbook Level Module Sub Goto_GSUTPF_Index() Worksheets("Coverage_Statistics").Activate End Sub Sheet Level Module Private Sub CommandButton1_Click() CommandButton1.BackColor = 4349166 ThisWorkbook.Goto_GSUTPF_Index End Sub I have closed, re-opened, saved a few times but no effect. I do, most strangely, also appear to have ended up with two identical copies of the same VBAProject. Any ideas please. Best regards Philip Bendigo, Victoria Australia
