change case

I have three radio buttons that the user can select Uppercase Lowercase Propercase When the form initializes the Uppercase radio button is set to true if the user selects one of the radio buttons I want the text already keyed into a textbox to update to the choosen radio button I have...

Hi all, I working on a spreadsheet which contains columns with strings. These strings are entered by different users. I need these columns to be in upper case always due to some reasons. But when I use code to change it, everything turns into uppercase but format of text is gone. eg: "This item...

The following macro isn't working. I have it placed in the code for Sheet1. Can anyone help me understand why it won't work? it is supposed to change data certain columns to "proper" and others to upper-case. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim...

Is there a way to run the codes below on every sheet in my workbook? I have 50+ sheets (tab1, tab2, tab3... tab50...) I musto to change column B and X to upper case and after do action find and replace. I using 2 macros, 1st is for change case to upper case, 2nd for find EXAMPLE 1 and replace...

Hello the VBA experts, I need help with a macro that will change the case of a string of texts to proper except for prepositions (e.g. and, or, about, the, etc.). Any help would be greatly appreciated. Thanks.

I have data coming in that looks like: <table border="0" cellpadding="0" cellspacing="0" width="147"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:694;width:14pt" width="19"> <col style="width:48pt" width="64"> </colgroup><tbody><tr...