In Excel, to change the case 'in place' press ALT + F11 to open the Visual Basic Editor, Insert > Module. Copy and paste in
Sub ToCaps() Dim r As Range For Each r In Selection r.Value = UCase(r.Value) Next r End Sub
then close the VBE. Select the cells to change then Tools > Macro > Macros, highlight ToCaps and click the Run button. You could also assign this macro to a button from the Forms toolbar or to a keyboard shortcut.
Thanks for your assistance with Lower case to Upper case, works great in word but unable to sort it in Excel, cant' seen to handle the VBE, any other easy way, or further explanations of VBE Thanks Skylooker
If you press ALT + F11 the VBE should open. On the Insert menu select Module and a white area should appear on the right hand side of the screen. Copy the code above and paste it into the white area. The result should look something like this: click here
Then close the VBE using the X, select the range of cells that you want to convert and Tools > Macro > Macros, highlight ToCaps and click the Run button.
That works a treat, but have you looked at a programme called ASAP utilities? click here There are loads of things you can do, just in case VoG™ ever goes on holiday and you can't wait for his return!!
copy the part of the spreadsheet that you want to toggle case on; paste in word; select the text to have toggled; shift+F3 until you have the desired result; copy from word and paste over original cells in excel.
This thread is now locked and can not be replied to.