Hi,
If I enter a word in any form say, mrExCEl in a cell...
I'd want to it to be changed to all large cap, ie MREXCEL
So I'd want to write in the VBA ...
"Read" Target.Value ...Then
'Now say it contains mrExCEl
Target.Value = "MREXCEL" ' i.e. the cell should fnally show MREXCEL
End If
All suggestions welcome
Also, out of interest, can I do the same in the worksheet rightaway w/o the VBA?
thanks a lot!
If I enter a word in any form say, mrExCEl in a cell...
I'd want to it to be changed to all large cap, ie MREXCEL
So I'd want to write in the VBA ...
"Read" Target.Value ...Then
'Now say it contains mrExCEl
Target.Value = "MREXCEL" ' i.e. the cell should fnally show MREXCEL
End If
All suggestions welcome
Also, out of interest, can I do the same in the worksheet rightaway w/o the VBA?
thanks a lot!