Replace & with 1 when entering in the textbox

Hello,
maybe:

Private Sub TextBox1_Change() Me.TextBox1.Text = UCase(Me.TextBox1.Text) Me.TextBox1.Text = replace(Me.TextBox1.Text,"&&","1") ' ... Me.TextBox1.Text = replace(Me.TextBox1.Text,"à","0") End Sub

Hello

if you are working in VB.Net, there is a more optimized way (in terms of execution time)

You need to derive the textbox and rewrite the ProcessCmdKey method
Here is an example in C# (the base language of .Net, VB.Net is "just" a skin VB)
https://codes-sources.commentcamarche.net/forum/affich-1526742-keydown-keypress#5

And something to convert from C# to VB.Net
https://lite.qwant.com/?q=c%23+to+vb&client=opensearch
--
When I was little, the Dead Sea was only sick.
George Burns

I didn't explain why it's not optimized to do Replaces in the Change event (and this applies regardless of the VB used, but I only have a good solution in .Net)

Let's say your textBox contains AZERTYUIOP and you've just typed à.

We will apply the 10 Replaces one after the other.
Each Replace will scan each character to see if it is the one it needs to replace:

• AZERTYUIOPà to find &,
• AZERTYUIOPà to find é
• etc...doing nothing until
• AZERTYUIOPà to find à, and there it finds à which it replaces with 0 so the textBox becomes AZERTYUIOP0

So the Changed event is triggered again and we start scanning AZERTYUIOP0 10 times for nothing.

In the end, 220 Replaces are executed and only one bears fruit.

Of course, it's done in the blink of an eye, but since I’m a bit twisted, I'll copy and paste

&é"'(-è_çà

into my textBox
There is a change, so

&é"'(-è_çà

becomes

1é"'(-è_çà

which will trigger a new change event, one of them "Change" currently executing (I don’t know which will take priority over the other...) will change the text back to

12"'(-è_çà

which will trigger a 3rd execution of the event, etc...etc...

At a glance, 10 Changed events will each perform 10 Replaces, hoping that all the parallel executions do not conflict.

That's when it will start to show, and I won't tell you if you press a key in the meantime....

--
When I was little, the Dead Sea was just sick.
George Burns

Hello and thank you for your responses,

I tested the first solution, the one with replace().
It’s fast but doesn’t work for the characters é, è, ç, and à.

I checked your link and made a conversion, but some lines of code are in red.

It’s a shame there isn't a function like ucase().
I will keep looking.

Thanks again for your responses and have a good Sunday.

Ludwig