Activex Combobox - VBA Code not running

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
Hi there,

Just wondering if anyone can help me.

I have an excel report that uses activex comboboxes and triggers VBA when they are changed.

The issue I have is that since MS rolled out an update earlier in the year, the report runs fine on some of the machines in my organisation, but doesn't on others...

Does anyone know of any setting or anything like that that I can change to see if it works? Or are there any temp files to be deleted or anything at all...it really is a hindrance for me at the moment as the report was used extensively for decision making around the org.

Thanks in advance,

E
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,796
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Which fix are you trying to run and which version do you have? You can simply delete the .exd files yourself if all else fails, but you do have to do it on all the machines. Better still, replace the activex with Form controls or data validation dropdowns. ActiveX controls on worksheets have always been unstable.
 

Colin Legg

MrExcel MVP, Like totally RAD man
Joined
Feb 28, 2008
Messages
3,497
Office Version
365, 2016
Platform
Windows
If the problematic update was only rolled out on some machines then, if a user on one of those machines saves a workbook, users on machines without the update won't be able to use that workbook.

So basically, if all machines have the update, then you should be able to run the fix Rory suggested on all machines and then all will be OK.
If only some machines have the update then the fix won't be any good. You'll need to replace the ActiveX controls with Forms controls (as Rory suggested too). The caveat is that, if a workbook was last saved by a user with the update installed, the ActiveX controls in that workbook can only be deleted by a user on a machine where the update is installed.

I don't know if I explained that particularly well; I blogged a more verbose version here.
 

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
Which fix are you trying to run and which version do you have? You can simply delete the .exd files yourself if all else fails, but you do have to do it on all the machines. Better still, replace the activex with Form controls or data validation dropdowns. ActiveX controls on worksheets have always been unstable.

I have already deleted the .exd files on these machines, but it still won't work...

I'll just re-engineer the report to use form controls as you have said...I just didn't want to have to do this as it is quite a large report and are a lot of triggers.

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,095,541
Messages
5,445,090
Members
405,316
Latest member
joaoamaro

This Week's Hot Topics

Top