Forcing Uppercase into Cells

  • Thread starter Thread starter mikepalm
  • Start date Start date
M

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
 
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
 
Back
Top