Consulting | Excel Examples
Keywords: OnEntry, Convert, Uppercase
Description: Example Visual Basic for Applications procedure converts lowercase text entered in a column to uppercase.
Tip: You can use an OnEntry procedure to run a Visual Basic for Applications procedure each time that data is entered into the worksheet. The procedure can convert lowercase text to uppercase is the active cell is in a specified range. The example converts entries in the second (B) column to uppercase.
Guide to the Example: Enter values in the first and second columns of Sheet1. Entries in the second column will be converted to uppercase upon entry.
Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.