3 letter capitalisation

Just curious, did you change the code so it looked like:

Select Case Len(Target.Value)
Case 2 To 5: myConversion = vbUpperCase
Case Else: myConversion = vbProperCase
End Select

(just checking on you <bg>)

Voodoodan wrote:
>
> The data being entered is specialised, so there'll be no need to type in
> any general, everyday names, as such.
>
> I've actually modified it a little now to capitalise all letters within
> 2-5 letters. This is because when people enter these words they will be
> acronyms of a certain team/unit. However, anything over 5 letters will
> likely be a team/unit's name in full, so it just needs the first letter
> to be capitalised.
>
> Dan.
>
> --
> Voodoodan
> ------------------------------------------------------------------------
> Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
> View this thread: http://www.excelforum.com/showthread...hreadid=505301

--

Dave Peterson

Close, I did it this way, however I prefer the neatness of your line!

Select Case Len(Target.Value)
Case Is = 2, 3, 4, 5: myConversion = vbUpperCase
Case Else: myConversion = vbProperCase
End Select

Dan.

Originally Posted by Dave Peterson

Just curious, did you change the code so it looked like:

Select Case Len(Target.Value)
Case 2 To 5: myConversion = vbUpperCase
Case Else: myConversion = vbProperCase
End Select

(just checking on you <bg>)

Voodoodan wrote:
>
> The data being entered is specialised, so there'll be no need to type in
> any general, everyday names, as such.
>
> I've actually modified it a little now to capitalise all letters within
> 2-5 letters. This is because when people enter these words they will be
> acronyms of a certain team/unit. However, anything over 5 letters will
> likely be a team/unit's name in full, so it just needs the first letter
> to be capitalised.
>
> Dan.
>
> --
> Voodoodan
> ------------------------------------------------------------------------
> Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
> View this thread: http://www.excelforum.com/showthread...hreadid=505301

--

Dave Peterson

Putting all the numbers is a nice way if you wanted to skip one of them. But
way too much work if you were checking up to (say) 32000 characters <vvbg>.



Voodoodan wrote:
>
> Close, I did it this way, however I prefer the neatness of your line!
>
> Select Case Len(Target.Value)
> Case Is = 2, 3, 4, 5: myConversion = vbUpperCase
> Case Else: myConversion = vbProperCase
> End Select
>
> Dan.
>
> Dave Peterson Wrote:
> > Just curious, did you change the code so it looked like:
> >
> > Select Case Len(Target.Value)
> > Case 2 To 5: myConversion = vbUpperCase
> > Case Else: myConversion = vbProperCase
> > End Select
> >
> > (just checking on you <bg>)
> >
> > Voodoodan wrote:
> > >
> > > The data being entered is specialised, so there'll be no need to type
> > in
> > > any general, everyday names, as such.
> > >
> > > I've actually modified it a little now to capitalise all letters
> > within
> > > 2-5 letters. This is because when people enter these words they will
> > be
> > > acronyms of a certain team/unit. However, anything over 5 letters
> > will
> > > likely be a team/unit's name in full, so it just needs the first
> > letter
> > > to be capitalised.
> > >
> > > Dan.
> > >
> > > --
> > > Voodoodan
> > >
> > ------------------------------------------------------------------------
> > > Voodoodan's Profile:
> > http://www.excelforum.com/member.php...nfo&userid=597
> > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=505301
> >
> > --
> >
> > Dave Peterson
>
> --
> Voodoodan
> ------------------------------------------------------------------------
> Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
> View this thread: http://www.excelforum.com/showthread...hreadid=505301

--

Dave Peterson