Is there a cache in Excel - Old VBA code seems to be running

[newcoder]

I had a msgbox a few days ago that stated:

Msgbox("you must call (AAA)AAA-AAAA for help").

This was changed to the following: And I have validated the code numerous times..
Msgbox("you must call (111)111-1111 for help").

However when I run this I still get (AAA)AAA-AAAA. However when I put a a break point in the code and step through it I get the new number (111)111-1111)..

It appears this old message is cached somehow, or am I missing something in the code? Is there a way that I might have compiled this and this is what is running?

I am really confused..

Any helpful thoughts?

cheers.

 

[RSXchin]

Search through all of your modules for "(AAA)AAA-AAAA ". Dont forget your obect modules too.

 

[newcoder]

I have...
I have step through it with Debug and I get the correct phone number, but run it from the command button I get the wrong number...

I am going crazy...

any other thoughts?

 

[RSXchin]

check the code in the command button

 

[newcoder]

nevermind... I am an idiot..

thanks.

 

[RSXchin]

I would suggest you change the code in the button to CALL the macro you have in the other module.