capital letters

[HGood]

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

[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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"HGood" <[email protected]> wrote in message
news:%[email protected]...
> 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
>

[HGood]

Thanks very much, I really appreciate this help.

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

Thanks,

Harold

"Earl Kiosterud" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "HGood" <[email protected]> wrote in message
> news:%[email protected]...
>> 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
>>
>
>

[RagDyer]

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!
==============================================

"HGood" <[email protected]> wrote in message
news:[email protected]...
Thanks very much, I really appreciate this help.

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

Thanks,

Harold

"Earl Kiosterud" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "HGood" <[email protected]> wrote in message
> news:%[email protected]...
>> 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
>>
>
>

[David McRitchie]

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.

"RagDyer" <[email protected]> wrote ...
> 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!
> ==============================================
>
> "HGood" <[email protected]> wrote in message
> news:[email protected]...
> Thanks very much, I really appreciate this help.
>
> I hadn't realized I'd have to go to a macro.
>
> Thanks,
>
> Harold
>
> "Earl Kiosterud" <[email protected]> wrote in message
> news:%[email protected]...
> > 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
> >
> > --
> > Earl Kiosterud
> > mvpearl omitthisword at verizon period net
> > -------------------------------------------
> >
> > "HGood" <[email protected]> wrote in message
> > news:%[email protected]...
> >> 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
> >>
> >
> >
>
>

[RagDyer]

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!
-------------------------------------------------------------------

"David McRitchie" <[email protected]> wrote in message
news:umG4Z9C%[email protected]...
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.

"RagDyer" <[email protected]> wrote ...
> 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!
> ==============================================
>
> "HGood" <[email protected]> wrote in message
> news:[email protected]...
> Thanks very much, I really appreciate this help.
>
> I hadn't realized I'd have to go to a macro.
>
> Thanks,
>
> Harold
>
> "Earl Kiosterud" <[email protected]> wrote in message
> news:%[email protected]...
> > 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
> >
> > --
> > Earl Kiosterud
> > mvpearl omitthisword at verizon period net
> > -------------------------------------------
> >
> > "HGood" <[email protected]> wrote in message
> > news:%[email protected]...
> >> 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
> >>
> >
> >
>
>