change case macro in excel 2003 or 2007

Posted by john_n_a69 January 22, 2012
john_n_a69's picture
New user

A long long time ago (in a galaxy far far away) i saw the source code for an excel macro which enabled me to change The case of the text within the highlighted cell. After assigning a short cut key, i could make the text all lc, all uc, or capitalise the first letter of each word. Where is it pls. TYVM (in advance)

Answers

#1
Posted by Dick4811 (not verified) on January 23, 2012
Dick4811's picture
New user

A book by John Walkenbach - Excel 2010 Power Programming with VBA Chapter 16 has a program that does this.
Because of copyright and size I will not reproduce here.
Maybe somebody else has a similar program.

#2
Posted by Dick4811 (not verified) on January 24, 2012
Dick4811's picture
New user

Also try Google and search for "excel change case"
Try this site http://www.cpearson.com/excel/ChangingCase.aspx

#3
Posted by brad2 on March 14, 2012
brad2's picture
Casual user

Click on the big ball, and type in the search bar Network and this should bring up various network options. Click on the preferred options and make your changes as required. mens pea coat | mink coat | morning coat | sport coat | wool coat | brown leather jacket |

Email Facebook Reddit Digg AddThis