Insert space if Textbox.value is certain length, remove space and last char with Backspace

Hi everyone,

I'm making a payroll management system, complete with payslips, employee files, tax forms, punch system for employees, etc.

To add a new employee to the system, I have a Userform full of text boxes, option buttons, list boxes... I have a textbox for Social Security Number. For the sake of readability, I want a space added after the first 3 digits then another after the next 3 digits, giving me something like ### ### ###. I managed to add the spaces with If statements in the textbox_Change sub but if I hit backspace, I can't get passed the spaces.

Here's my code:

Please Login or Register  to view this content.

This causes the problem that when you encounter one of these spaces you get back to the length that requires a space, puts it back and you can't go back further. I tried using Textbox_KeyPress and Textbox_KeyDown to keep only the left 2 or 6 characters and end up with only the left 1 or 5 characters.

Anyone has any idea how I could achieve this?

Just now I've tried with something like this :

Please Login or Register  to view this content.

2022-02-27_17-20-45.gif

But I think it's not a good solution, because the code is not short.

I think it's not a good solution, because the code is not short.

@karmapala
Wow, actually the length of the code isn't really a problem to me, as it happens "in real time" so I think you can barely see a delay. I like your solution and I can see that it's working.

@JEC.
This seems to work fine too. The way I understand it, it's pretty much karmapala's solution in one line. Am I right?

Thank you for the replies. I will try them later today as I've been on the computer working on other parts of my project for HOURS, so my brain is fried right now.

Now, say I would like to recreate it for another format (Postal Code here are written as A1A 1A1) how would I do that?

Possibly...
code didn't test well.

This only accepts numbers.

Please Login or Register  to view this content.

Originally Posted by nightseeker‎

Now, say I would like to recreate it for another format (Postal Code here are written as A1A 1A1) how would I do that?

If you mean any 3 characters then

Please Login or Register  to view this content.