How do you get Excel VBA to realize the default properties again

[Daxton A.]

I was coding and used a module name of numberFormat() and realized that it was already a default property of excel. Now, I changed the name of my module but Excel still mirrors the name¿

I even searched the whole workbook using CTRL + F and didn't find any other name usage other than the default property names.

Now, i cannot get my actual .NumberFormat property to work.

Also, I cannot upload the spreadsheet because it is too big. Any clue?

Thanks,
Daxton

[June7]

Is it an issue in a new workbook?

[Daxton A.]

Well this maybe an issue with the RAM as well. That PC needs a replacement.

I was able to open one of my previous copies and just rewrite my module with a different name but that still doesn't increase my future endeavor knowledge of how to write "Microsoft's Default Code" back the way that it was. (Don't know the proper terminology)

[June7]

If it is not an issue in other workbooks, possibly problem wb is corrupted.

I have never encountered this but then I never named a module same as intrinsic function or property.

[Daxton A.]

Nope, it isn't a ram issue. I tried it on a new workbook on a different pc and it did the same thing.

[Daxton A.]

Quite possibly, a new task for Bill Gate's to tackle.

[June7]

On another PC? Exactly what did you do in that new workbook? Did you do the same error?

What version of Excel?

[Paul_Hossler]

One thing you can try

1. Export the numberFormat module
2. Remove it from the WB
3. Save WB
4. Close Excel

5. Use Notepad and edit numberFormat.bas

The first lines look like

Attribute VB_Name = "numberFormat"

Option Explicit

so change the VB_Name to "something" and save it as "something.bas"


6. Open Excel, open WB, import "something.bas"

[Daxton A.]

Yes that worked for me Paul, thanks. So that tells me that as long as the Module is still in existence, then the system code is still funky. Thanks for the wisdom everyone!

Daxton Allen

[Aflatoon]

You should also just be able to type something like:

Dim NumberFormat

and then delete it in order to reset the capitalisation (I assume that was the only issue).