Thread
:
VBA automatically updating variable names
View Single Post
#
1
Posted to microsoft.public.excel.programming
Zack Barresse[_3_]
external usenet poster
Posts: 101
VBA automatically updating variable names
Hi Mike,
Why not try the popular hungarian-type notation? Here are some examples ...
Type - Variable Name
----------------------------------
Boolean blnWasCreated
String strFileName
Long lngRow
Range rngFilter
Variant varUniqueArray
HTH
Regards,
Zack Barresse
"Mike T" <Mike
wrote in message
...
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
Reply With Quote
Zack Barresse[_3_]
View Public Profile
Find all posts by Zack Barresse[_3_]