Excel Question

[40Hands]

I have a cell. The value of the cell will be Y, N, N/A via a drop down selection. If the person types the letter in lower case y, n, n/a I want it to make it a capital letter automatically.

 

[BlueWeasel]

Is it possible to use the UPPER (converts a text string to all uppercase) function on a drop-down list?

 

[theknight571]

Here ya go.

If you want it to apply to the entire worksheet, then remove the "If" statement.

 

[theknight571]

Just realized there might be some issues with formulas using that code globally on the worksheet... so if you can limit it to a certain range, then you might want to. 🙂

I didn't write the code... but if you need something different let me know and I'll take a look.

 

[TSDible]

You could put some simple vba in the worksheet that will automatically change a it when someone makes a lowercase entry. That way, there wouldn't be any formula in the field. However, you would have to have macros enabled for it to work.

 

[TSDible]

Just for reference, here is some code that I wrote quickly that will convert all entries in column A to uppercase.

It needs to go in the sheet object.