Forcing Uppercase into Cells

[mikepalm]

I'm looking for a way to force uppercase into cell when user enters a
lower case. IE a format function of sorts. Mike

 

[DARREN FONG via OfficeKB.com]

Mike,

here is a page that might help

http://exceltips.vitalnews.com/Pages/T0585_Forcing_Input_to_Uppercase.html

 

[mikepalm]

Thanks a bunch

 

[amag]

Hi Mike,

Can a similar functionality be added to calculate formula. e.g. if i
hit enter in a particular cell lets say B1 then it shud actually give
me value as A1*B1.

If its possible i think it can be very useful in cases where we input
numbers where one number is constant(i.e. refers to particualr cell)
and the other a variable(i.e. to be input by user). Then you can just
ask the user to input the number and need not worry about linking.

Something like:

Private Sub RANGE_Change(ByVal Target As Range)
With Target
If Not .HasFormula Then
.Value = A1 or A DEFINED NAME TAG*(.Value)
End If
End With
End Sub

-amag