Starting to hate Excel - Making -any- change to the VBA breaks this, for some reason

RockandGrohl

Well-known Member
Joined
Aug 1, 2018
Messages
596
Office Version
  1. 2010
Platform
  1. Windows
Have the following code in a module:

Code:
AdSelect.LDAlts = "---A---" & Chr(10) & Cells(ActiveCell.Row, "F").Value & Chr(10) & Chr(10) & "---B---" & Chr(10) & Cells(ActiveCell.Row, "G").Value & Chr(10) & Chr(10) & "---C---" & Chr(10) & Cells(ActiveCell.Row, "H").Value


If I open the workbook and use it as normal, there's no problem.

I press a button on the workbook and it executes a long string of macros which then provides a Userform with a large amount of content on it.

If I change a completely separate macro, anywhere else within the same workbook, it breaks and when I press the button to open the userform, I get this:

"Method or Data Member not found"

It highlights the above code at the top.

I have no option to debug etc.


There have been no name changes to this sheet whatsoever, the code inside hasn't been changed in over 3 weeks and it gets regular daily use by individuals.

If I don't make any change to the code, it works fine. As soon as I input anything into the VBA, in any module, it breaks.


literally, if I go in and write " 'lol" anywhere in any module, it breaks.


Any ideas?
 

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.

RockandGrohl

Well-known Member
Joined
Aug 1, 2018
Messages
596
Office Version
  1. 2010
Platform
  1. Windows
I've just checked - it's only my PC that's doing this. This is weird + annoying.

It's also on other spreadsheets, if I open a userform, it's ok, and then if I add anything to the code, it fails to compile.
 
Last edited:

RockandGrohl

Well-known Member
Joined
Aug 1, 2018
Messages
596
Office Version
  1. 2010
Platform
  1. Windows
Fixed by restoring a Windows version to 1st April this year.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,791
Messages
5,638,329
Members
417,021
Latest member
moon miner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top