VBA Acting Up

[Menessis2]

I have been working on a project for a while now. I have the file on a flash drive. I tried working on it at my GF's and Excell is CTD for some reason. The project is using combo boxes to make a selection and then put them in a named range.
This has been working fine right up to now. This happens with at least two so far. I renamed the range just to see what would happen cut still got the CTD. Then I tried one other combo box and it got as far as writing it then CTD!

I ran a virus scan, found nothing.

Out of ideas.
Can anyone think of anything?

Edit: just tried another working project with combo boxes and it all works fine.

Thanks
Menessis

 

[Menessis2]

With this install the references....
ALT + F11 >> Tools>> references isn't even there! I get as far as clicking the "References" on the menu and get the error message "error escessing the system registry".

 

[Fluff]

That sounds like you have some serious problems.
Did you create a backup of your system registry before using CCleaner?

 

[Menessis2]

WoW traced latest problem to not running Excell as Admin!

But is still behaves like it did before. CTD after the selction from combo box is written to a cell. When watching closely as I pressed F-8 I see the information in the cell just before it crashes.

What a PITA! (Pain In The ***)

 

[Menessis2]

The file that is not working started out on the Win7 pc and doesn't work on the Win10 pc. I going to look and see what references are selected on the Win7 pc to compare.

 

[Michael M]

Compile error Cant find project or library

When you reinstalled Office, did you include Developer in the Install.
Thats the softwatre that allows macros to be created and used !!