View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike T[_2_] Mike T[_2_] is offline
external usenet poster
 
Posts: 3
Default VBA automatically updating variable names

I defined 2 functions in the same module. One function use lower case 'x' as
the arguement and the other uses upper case 'X' as the arguement(see below).
VBA automatically changes one of the arguements to match the other. It does
the same thing even if I put each of the functions in different modules.

Function fun1(x As Integer)
End Function

Function fun2(X As Integer)
End Function

Can someone please explain this and if I can prevent it? Thanks