【转帖】vba crashing whenever you change a sub90 or function90
 

vba crashing whenever you change a sub() or function()
in a specific module i change anything reguarding a sub() or function() or in the declarations area its crashed the program! weather it be excel or sw's!
anyone know what is going on?????
you would have to show the code and an example of what you change to crash the program, and describe what you mean by crashing it
you select anywhere in the first few lines of the code, click enter, or delete some stuff and excel locks.... gives an error to send to microsoft and then closes, i means it not like i am running anything, just trying to edit it.....
luke, ill email you the macro file.....
copy all your code into a new module. cut and paste. i had this same issue in access vba. i think i even cut and paste into the same module. some wierd vba module corruption thing.
yeah, i ended up copy and pasting to a word doc, then opening a whole new vba control and pasting it into that.. otherwise it would crash...
quick