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

Try this:

Insert this line anywhere in your code:
Dim Value
(hit enter)

Then delete that line.

And test it.

Tom Med wrote:

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

--

Dave Peterson