View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Med Tom Med is offline
external usenet poster
 
Posts: 27
Default Auto Capitalization annoyance

I have a utility that exports VBA code and checks it into source
control. However VBA capitalization seems to automatically change
things. For example

Target.Value ' where target is a range

gets changed to

Target.value

this capitalization or the reverse behaves differently on different
computers. The effect of this is that lots of modules seem to be
changed when it is in fact VBA doing or undoing this capitalization.
Does anyone know what controls this?

Thanks
Tom