Auto selecting specific characters in textbox

Hi,
I have a text box in a userform, that contains both a date and a time in a single string, for instance: "02/05/2020 14:00"

What I want is this:
say I wanna change the date to 04/07/2020.
As soon as I type "04", "05" will automatically be highlighted (skipping whatever separator there is, in this case "/") so that i can immediately go on to typing "07" without moving the cursor or fiddle with the arrow keys to position the text cursor manually.

Or alternatively, allowing the user to jump easily to the next part in the date/time format using the arrow keys.
Say, if the user clicks the right or left arrow key for example, the next/previous part will be highlighted, ready for the user to change. The user will be able to use the arrow keys to cycle through the different parts ( "02", "05", "2020", "14", "00" )

I don't have any idea as to how to start.. It's a little out of my vba territory.. that's why I don't even have an initial code to show for.. Sorry..

Thanks!

You may want to look into using a date/time picker instead of a textbox for this.

I don't have it, under additional controls..
I'll watch some tutorials ..
Thanks

If you have not solved it yet, please attach your file and I will try to work on it directly.

Alternative is to enforce numbers only input in the textbox, with exact length.

Ex: Assuming always mmddyyyyhhmm format (24 hour clock). 12 char length.
040720201100

Then use Format() function to format it to date time string, then if needed you can use CDate on it to convert to datetime value.

Sample code:
In textbox KeyPress event...

Please Login or Register  to view this content.

Then in some other command button (i.e. when you submit form data to sheet etc).

Please Login or Register  to view this content.

Now this won't accommodate for users typing in yyyymmddhhmm or some other format. You could validate each key press for valid value only... but that's bit more complicated.
Ex: Char position 1 must be only 0 or 1, position 2 must be 0-2 if char1 is 1, 0-9 if char1 is 0 etc...