Separate two year values in a textbox with a slash - vba

[Kelly mort]

I want to enter into a textbox

2019/2020

So what I want to do is to make sure that only numbers and the forward slash is allowed. No spaces accepted.

So when I enter 2019 then the slash comes automatically. Then I add the other year.

My knowledge is limited on that trick and I need Tech support.

Thanks

[Leith Ross]

Hello Kelly,

Where is the TextBox: Worksheet or UserForm?

[Kelly mort]

Hello Kelly,

Where is the TextBox: Worksheet or UserForm?

On a userform

[Leith Ross]

Hello Kelly,

Thanks for letting me know. I will write the code and post it.

[Kelly mort]

Hello Kelly,

Thanks for letting me know. I will write the code and post it.

Okay. Sure. I am waiting

[Leith Ross]

Hello Kelly,

Sorry, I got slammed with phone calls. Here is the code. I used TextBox1. If your TextBox name is different then change it in the macro.

Set your TextBox property MaxLength to 9. This will limit the input to only 9 characters and no more.

Please Login or Register  to view this content.

[YasserKhalil]

I think reset the slash would be

Please Login or Register  to view this content.

As when using backspace after the slash is inserted, the code doesn't insert it again

[Kelly mort]

Cool. One thing I observed is that after I use the delete keys, the validation does no longer work.

I don't know if you can also duplicate this issue at your end.

[Kelly mort]

I think reset the slash would be

Please Login or Register  to view this content.

As when using backspace after the slash is inserted, the code doesn't insert it again

I think your line resolved the previous concern I raised.

[Leith Ross]

Interesting. I tested the code and had no problems.

[Kelly mort]

Interesting. I tested the code and had no problems.

I appreciate your help. Now this thread can be marked as "solved". Thanks