|
Make Text to Uppercase
This macro will change all text within the selected cells to uppercase. It works only on selected cells within Microsoft Excel and it will work on ranges that include rows, columns, and both at the same time.
Where to install the macro: Module
Converts Text in Cells to Uppercase
Sub Uppercase()
'
'This will make the text of any selection of cells uppercase.
'
For Each x In Selection
x.Value = UCase(x.Value)
Next
End Sub
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
For Excel Versions Prior to Excel 2007
Go to Tools > Macros > Visual Basic Editor
For Excel 2007
Go to Office Button > Excel Options > Popular > Click Show Developer tab in the Ribbon. Then go to the Developer tab on the ribbon menu and on the far left Click Visual Basic
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- Go to the menu at the top of the window and click Insert > Module
- Another window should have opened within the Visual Basic Editor's window. Within this new window, paste the macro code. Make sure to paste the code underneath the last line of anything else that is in the window.
- Go to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- Directly underneath your excel file called VBAProject(your file's name here), click the Microsoft Excel Objects folder icon to open that drop-down list.
- Then, at the bottom of the list that appears, double-click the ThisWorkbook text.
- A new window inside the Visual Basic Editor's window will appear. In this new window, paste the code for the macro. Make sure to paste this code underneath the last line of any other code which is already in the window.
- Go to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Directly underneath your excel file called VBAProject(your file's name here), click the Microsoft Excel Objects folder icon to open that drop-down list.
- Within the list that appears you will see every worksheet that is in that excel file. They will be listed as such: Sheet1(NAME OF SHEET HERE) and under that will be Sheet2(NAME OF SHEET HERE). Select the sheet in which you want the macro to run and double-click that sheet.
- A new window inside the Visual Basic Editor's window will appear. In this new window, paste the code for the macro. Make sure to paste this code underneath the last line of any other code which is already in the window.
- Repeat steps b and c for every sheet you want the macro to work in. Putting the macro in one sheet will not enable it for any other sheets in the workbook.
- Go to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.
Similar Helpful Excel Resources
I am using the following code to populate a cell
Code:
Range("HedgeComm").Value = "NO HEDGE ADJUSTMENT YET TO REPORT FOR " & Cells(VROW, 2).Value
the part "Cells(VROW, 2).Value" is lower case and I want it to be uppercase with out changing the source value.
Any ideas??
Thanks,
Hi,
I know theres a command to make all text uppercase but can't find it? can anyone help/ i just want to make a range B5:B20 All uppercase.
Thanks
I have seen code to make selected cells uppercase, and I have seen code to make a specific column uppercase (ex: make Column C Uppercase). I am trying to figure out how to make a SELECTED column uppercase.
I am going to add this code to my toolbar (I can already do that), so I want to make it so you would select an entire column, hit the button, and that column would become all Uppercase.
I am thinking you might use some variation on:
ActiveCell.Value = UCase(ActiveCell.Value)
and make it loop until the last cell with data, but I dont know how to do that.
I would like to convert my entire column to uppercase in Excel 97. Is that
possible?
Thank you
This should be an easy one...
In a specified range of cells, I want for any characters (alpha) typed in those cells to show up as uppercase regardless of how they're typed (and no, CAPS LOCK is not the way I want to go!)
Thanks!
Is there a function that allows me to me an entire column into lower case letters or uppercase letters?
If I have few lower case values in my column B how can I convert them to uppercase? I see that every one suggest to use =upper(B) but where and how should I use this function?
Thanks in advance.
Hi,
I am working with a spreadsheet of names and addresses. The data was entered in lowercase but I would like to convert it all to uppercase. I have tried the UPPER function, but that does not seem to convert text already entered within the same cell. I am looking for a solution that would allow me to convert all the cells as they are without have to cut and paste. Any ideas?? :o
Thanks!
Linda
I am creating a data sheet to be completed by other users. I would like to
format the text cells (name, etc) to have text entered as uppercase
automatically although the user might use title or lower case.
UPPER function cannot make cell look at itself and perform the function
Excel 2003
This formula should be very often to use, but i cant found it anywhere, so i ask this here
For example in a1 is :
mike is playing basketball, he is very great player
i want to make it in b1 to be uppercase only in first letter so :
Mike is playing basketball, he is very great player
i know about proper formula =proper(a1) , but proper formula is make uppercase to all first letter in all words, we just need first letter in first words to be uppercase (and to every first words after dot if it can)
|
|
