Consulting | Excel Examples

Force Uppercase Entry

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.


Last modified: May 21, 1996