Cell Always upper case regardless of input

[Georgia Golfer]

Hey again.

Working on a new spreadsheet & I want A1:A50 to be capitilized regardless of what the operator inputs. There will only be 2 options for the user to put in, A & B, so if they enter a, I want the cell to display A & if they input b, I want the cell to input B

Almost like Caps Lock is always on for this range of cells.

Thanks much

[VBA Noob]

Try using data validation to force the user to enter in upper case

http://www.dailydoseofexcel.com/arch...ce-upper-case/

VBA Noob