Convert uppercase to lowercase
in [Programming]
|
Prev: updating with now()
Next: Identifying a Pivot Table
From: JLGWhiz on 22 Dec 2009 14:13 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" <mervyn-thomas(a)ntlworld.com> wrote in message news:Uv7Ym.100012$lP6.30709(a)newsfe13.ams2... > 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" <mervyn-thomas(a)ntlworld.com> wrote in message > news:Pr7Ym.100011$lP6.24193(a)newsfe13.ams2... >>I particularly liked this solution but thanks to everyone who answered >> "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote in message >> news:OwAn4jygKHA.1540(a)TK2MSFTNGP06.phx.gbl... >>> Sub dk() >>> Dim nm As Range >>> For Each nm In Range("A2:A25") 'substitute actual range >>> nm = >> Next >>> >>> End Sub >>> >>> >>> "Mervyn Thomas" <mervyn-thomas(a)ntlworld.com> wrote in message >>> news:Ao6Ym.1125$Hy7.328(a)newsfe06.ams2... >>>> Does anyone have a bit of code to convert a file of conatcts all in >>>> UPPERCASE to Lower Case? >>>> >>> >>> >> >> > > |