Forcing Uppercase into Cells

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

Mike,

here is a page that might help

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200601/1

Mike,

here is a page that might help

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200601/1

Thanks a bunch!

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