TextBox SetFocus Problem on UserForm

Hi, I am having trouble with the setfocus command and I have done a bit of searching but my knowledge of vba is very little.

I have managed to get the following code with help but the setfocus in the Private Sub UnitCost_Change() is not working.

I would like a number value to be entered in TextboxControl and on typing a value if the data is not in the correct format a message will appear with an OK Button. When OK is selected I would like the wrong data to be cleared and the cursor back in the TextboxControl.

The code below is working fine except the SetFocus doesn't appear in the activate control.

Here is the code in Module mode:

Please Login or Register  to view this content.

Here is the code in Userform mode:

Please Login or Register  to view this content.

Thanks in advance.

Administrative note

Post moved to correct forum.

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

This code works for me...Perhaps you should upload a sample file...

Please Login or Register  to view this content.

This only removes the last character

Please Login or Register  to view this content.

I don't get any issue from the .setfocus on my test file

you can check what kind of key user press:

Please Login or Register  to view this content.

Why would you need to set focus to the active control?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Cross-posted TextBox SetFocus Problem on UserForm

I think you missed my point. The active control already has the focus, otherwise it wouldn’t be active.