View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zone Zone is offline
external usenet poster
 
Posts: 269
Default Dimmed Keyword as Variable

I stupidly dimmed keyword Val as a variant in a userform, type variant,
like this:

Dim HAL, VAL

Now, in every module that Val appears, it as appears as VAL. Yikes! I
found the Dim statement as changed it to

Dim HAL, VVAL

but all the Val statements in other modules still show as VAL.
Obviously, VAL was not dimmed as public, so I don't know why this is
happening! How do I get the VAL in the other modules to return to
their normal capitalization (Val)?

Thanks, James