Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000: VB code for changing caseof text
I am hoping some kind person can help me with this Excel 2000 problem......
I need a short piece of VB code I can attach to a Button in the tool bar, such that when I select a cell containing text it converts it from capitals to small case or even better, capitalise just the first character of the sentence (or alternatively work like the 'proper' function capitalise the first letter of each word...) I can do this easily in Word by pressing shift-F3, but there does not appear to be a similar function in Excel 2000. Thanks for your help. Patrick Worcestershire, UK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000: VB code for changing caseof text
ActiveCell.Value = strConv(ActiveCell.Value, vbProperCase)
or use vbLowerCase or vbUpperCase or for the first character Dim sStr as String sStr = strConv(ActiveCell.Value,vbLowerCase) sStr = ucase(left(sStr,1) & Mid(sStr,2) -- Regards, Tom Ogilvy "pgnl" wrote in message . uk... I am hoping some kind person can help me with this Excel 2000 problem...... I need a short piece of VB code I can attach to a Button in the tool bar, such that when I select a cell containing text it converts it from capitals to small case or even better, capitalise just the first character of the sentence (or alternatively work like the 'proper' function capitalise the first letter of each word...) I can do this easily in Word by pressing shift-F3, but there does not appear to be a similar function in Excel 2000. Thanks for your help. Patrick Worcestershire, UK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000: VB code for changing caseof text
Patrick
Chip Pearson has a CaseConvert add-in freely downloadable from his downloads site. http://www.cpearson.com/excel/download.htm Scroll down to CaseCovert and download to your Office\Library folder. Load it through ToolsAdd-ins Gord Dibben Excel MVP On Mon, 28 Nov 2005 22:38:33 GMT, "pgnl" wrote: I am hoping some kind person can help me with this Excel 2000 problem...... I need a short piece of VB code I can attach to a Button in the tool bar, such that when I select a cell containing text it converts it from capitals to small case or even better, capitalise just the first character of the sentence (or alternatively work like the 'proper' function capitalise the first letter of each word...) I can do this easily in Word by pressing shift-F3, but there does not appear to be a similar function in Excel 2000. Thanks for your help. Patrick Worcestershire, UK |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000: VB code for changing caseof text
Many thanks for your replies, I have now found some code and adapted it to
do what I want... Patrick Worcs, UK "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Patrick Chip Pearson has a CaseConvert add-in freely downloadable from his downloads site. http://www.cpearson.com/excel/download.htm Scroll down to CaseCovert and download to your Office\Library folder. Load it through ToolsAdd-ins Gord Dibben Excel MVP On Mon, 28 Nov 2005 22:38:33 GMT, "pgnl" wrote: I am hoping some kind person can help me with this Excel 2000 problem...... I need a short piece of VB code I can attach to a Button in the tool bar, such that when I select a cell containing text it converts it from capitals to small case or even better, capitalise just the first character of the sentence (or alternatively work like the 'proper' function capitalise the first letter of each word...) I can do this easily in Word by pressing shift-F3, but there does not appear to be a similar function in Excel 2000. Thanks for your help. Patrick Worcestershire, UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Column Format not changing. | Excel Discussion (Misc queries) | |||
Changing a Data Source in Excel 2000 | Excel Discussion (Misc queries) | |||
2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) | Excel Programming | |||
+ sign changing to - in Excel 2000???? | Excel Discussion (Misc queries) | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming |