msgbox Vs MsgBox

[JeffGrant]

Hi All, for some reason, I noticed today that every occurrence of the function MsgBox appears in my VBA Code as msgbox and is no longer coloured in Blue as a reserved word.

It does not seem to affect the functionality of the code, but is very strange.

Has anybody else seen this and how can I get it back to what it was?

There is no Dim msgbox in any of my code. Looks like the compiler is doing this all on its own.

Any ideas?

 

[RoryA]

Perhaps there was a variable/routine/module called msgbox. To rectify try adding a declaration of Dim MsgBox and then delete it again.

 

[JeffGrant]

Hi Rory,

I put in a Public MsgBox as String statement, saved the file, then deleted the Public MsgBox as String declaration.
In every module, the function now appears as MsgBox. Thanks for that.
What happened though?

Please correct me if I am wrong, but isn't the function MsgBox also supposed to be blue?

 

[RoryA]

It should be whatever colour you have set for Identifier text

 

[JeffGrant]

Ah Ha....worked it out. Apparently the inbuild function text colour has changed some how, not the identifier text colour. Because the colour of other inbuilt functions such as InputBox, Ucase etc has also changed.

I cant see where to reset it, so as long as it doesn't affect the coding, it is not important.

thanks

 

[RoryA]

The colour for functions is the identifier text colour.

 

[JeffGrant]

all good. thanks.