I have and order entry spreadsheet for trading that in cell A1 goes a stock symbol..ex yhoo
I want it to automatically capitalize upon entry so yhoo becomes YHOO but without hitting a macro command
i tried this with no success,
Public Property Get UpperA1() As Variant
Range("a1").Formula = Upper("a1")
End Property
still does not capitalize the entry in A1, any help with this?
thanks. M
I want it to automatically capitalize upon entry so yhoo becomes YHOO but without hitting a macro command
i tried this with no success,
Public Property Get UpperA1() As Variant
Range("a1").Formula = Upper("a1")
End Property
still does not capitalize the entry in A1, any help with this?
thanks. M