I particularly liked this solution but thanks to everyone who answered
"JLGWhiz" wrote in message
...
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = StrConv(nm.Value, vbProperCase)
Next

End Sub


"Mervyn Thomas" wrote in message
...
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?

PS with all these methods how do you find in the VB help the various
options in your StrConv(nm.Value, vbProperCase) ? Or is their a decent
manual somwehere? I would much prefer being able to find it myself rather
than bother you guys!
Thanks again!
Mervyn

"Mervyn Thomas" wrote in message
...
I particularly liked this solution but thanks to everyone who answered
"JLGWhiz" wrote in message
...
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = Next

End Sub


"Mervyn Thomas" wrote in message
...
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?

In the VBE, you can put your cursor in the word/method you are interested in
learning about and press F1, this will take you directly to the help section
it is in.

I just read some books, check this forum out a lot and you come across a lot
of functions that other people use, then learn about it. It takes time but
you can catch on quickly.
--
Cheers,
Ryan


"Mervyn Thomas" wrote:

PS with all these methods how do you find in the VB help the various
options in your StrConv(nm.Value, vbProperCase) ? Or is their a decent
manual somwehere? I would much prefer being able to find it myself rather
than bother you guys!
Thanks again!
Mervyn

"Mervyn Thomas" wrote in message
...
I particularly liked this solution but thanks to everyone who answered
"JLGWhiz" wrote in message
...
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = Next

End Sub


"Mervyn Thomas" wrote in message
...
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?







.

Some of them are difficult to find if you start from scratch. You can find
the options for StrConv by opening VBE Alt + F11 and typing that term in the
VBA help search box. Then select it from the topic listing when it shows.
Or you can do it like Ryan suggests and select it with the mouse, then press
F1 key.

I spent many hours searching the help files when I first began to write
code. I was not aware that the news group existed back then, but it was a
good learning process, because I found many things that I later used, plus
it gave me a broader view of what VBA could do. I am still learning and
find that I have only scratched the surface of VBA capabilities, although I
have written some pretty complex code before. The main thing is to have a
good understanding of the conventions used by the designers of VBA. If you
can get into their heads a little bit, it will help you to find methods and
tools in the VBA help files.


"Mervyn Thomas" wrote in message
...
PS with all these methods how do you find in the VB help the various
options in your StrConv(nm.Value, vbProperCase) ? Or is their a decent
manual somwehere? I would much prefer being able to find it myself rather
than bother you guys!
Thanks again!
Mervyn

"Mervyn Thomas" wrote in message
...
I particularly liked this solution but thanks to everyone who answered
"JLGWhiz" wrote in message
...
Sub dk()
Dim nm As Range
For Each nm In Range("A2:A25") 'substitute actual range
nm = Next

End Sub


"Mervyn Thomas" wrote in message
...
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?