capital letters

  • Thread starter Thread starter Earl Kiosterud
  • Start date Start date
E

Earl Kiosterud

Harold,

Although Autocorrect could be used, it would kick in any time you typed a y
or n, even in other Office programs.

Probably the best is an event-fired macro that makes the changes only when
you're in the column of interest. Paste this into the sheet module in the
Visual Basic Environment (Alt-F11).

Private Sub Worksheet_Change(ByVal Target As Range)
' Routine changes lower case to upper case in a column
Dim Coll As Integer
Coll = 2 'column to be converted
If Target.Column = Coll Then
Application.EnableEvents = False ' prevent re-firing
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End If
End Sub
 
Hi,

I have a form where in one column of cells, either Y or N is supposed to be
entered.

Is there a way to convert a "y" to "Y" so that they look a bit tidier? This
conversion would occur automatically no matter if they entered a "y" or "Y".

Thanks for any ideas.

Harold
 
Thanks very much, I really appreciate this help.

I hadn't realized I'd have to go to a macro.

Thanks,

Harold
 
If you don't wish to use code, you'll have to use a second cell.

You could have a column for user input, which would format to "White"
(invisible), with a "y" or "n" entry, and then the second cell would contain
a formula to display, for presentation purposes, the "y" or "n" entry in
upper case.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Thanks very much, I really appreciate this help.

I hadn't realized I'd have to go to a macro.

Thanks,

Harold
 
Hi RagDyer,
Entering a letter into a column where you can't see it, is rather
obtuse. Entering a letter into a hidden column without a macro
is I think impossible. I'd stick with Earl's answer.
 
Just offered an alternative to code because of the "tone" of the OP's
answering comment.

A lot of users are not "comfortable" using it.

If the columns are side by side, where an entry into one is immediately
evident (visible) in the next cell, I don't believe that's too obtuse.

--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi RagDyer,
Entering a letter into a column where you can't see it, is rather
obtuse. Entering a letter into a hidden column without a macro
is I think impossible. I'd stick with Earl's answer.
 
Back
Top