PC Review


Reply
Thread Tools Rate Thread

Auto Capitalization annoyance

 
 
Tom Med
Guest
Posts: n/a
 
      20th Sep 2007
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

 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      20th Sep 2007
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Capitalization Looping through Microsoft Excel Misc 1 18th May 2010 04:38 PM
Auto Capitalization The DixieFlatline Microsoft Word Document Management 25 8th Aug 2009 06:15 PM
Auto capitalization =?Utf-8?B?S2VubmV0aCBFcGxleQ==?= Microsoft Word New Users 9 16th Jul 2006 09:26 PM
auto capitalization =?Utf-8?B?d2lsbA==?= Microsoft Outlook 9 24th Feb 2005 07:18 PM
Re: Auto capitalization =?Utf-8?B?TGVl?= Microsoft Word New Users 0 27th Apr 2004 03:51 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:01 PM.