Write only first letter in row VBA

[KlausW]

Hi every one
I have a challenge
In an Excel sheet I use for work planning, you write T for service, S for sailed and F for free.
In row 35.
It also goes very well, but when I write T on a Tuesday or Thursday, it will say Tuesday or Thursday, and if I write S on a Sunday, it will say Sunday, and if I write F on a Friday, it will say Friday . Is there a VBA solution so that Excel only writes the first letter.
Any help will be appreciated
Best Regards
Klaus W

 

[Cubist]

Can you post what has been working for you? Not clear what you're trying to do exactly.

 

[KlausW]

Can you post what has been working for you? Not clear what you're trying to do exactly.

Hi Cubist I will return

 

[Trevor G]

Have you tried creating a validation list for the 3 options and also check your excel Preferences, Fomula and deselect Auto complete.

Also a good idea to post some example data.

 

[KlausW]

Hello again, I have posted a picture that shall explain what happens in row 35 when I type the letters as described in #1

In column 36, show what it should look like. However, it must appear in row 35.

Does it make sense?

Best regards

Klaus W

 

[Alex Blakenburg]

What do you have in Row 9 and the other hidden rows between 11 and 35 ?

 

[KlausW]

What do you have in Row 9 and the other hidden rows between 11 and 35 ?

Many formulas that calculate what should happen based on the letters you type in row 35. Nothing that I have an effect on row 35. In Row 9 stand public holidays in Denmark

 

[Alex Blakenburg]

Insert a blank row after row 9, you can hide it if you want.
Then see if the issue you are experiencing goes away.

 

[mumps]

I'm not sure if I understood correctly, but try this macro in the worksheet code module.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    Application.EnableEvents = False
    If Intersect(Target, Range("C35:I35")) Is Nothing Then Exit Sub
    Target = Left(Target, 1)
    Application.EnableEvents = True
End Sub

 

[Alex Blakenburg]

@mumps, I believe the underlying issue is that Excel is trying to help with data input using autocomplete using previously used words in the same column.
A fully blank row is the top border of this, and the previously used words may or may not include the first row depending on whether Excel recognises it as being a Heading row. (I do not have a definitive idea of how Excel determines whether it is or is not a heading row)

The auto complete uses the same logic as can be mimicked by using Alt+Down Arrow on the next data entry row of a column. It produces a drop down list in alphabetical order of the previously used entries in that column, which is the same list auto complete is using.

The theory is that if Klaus puts a blank row before the Monday Tuesday heading row, it will recognise Monday Tuesday... as the heading row and exclude it from the auto complete / previously used text list.
If that fails using your macro might be the logical next step.

I have used alt+down arrow in the 2 images below:

This may help (1.5 mins)