Modal issues when cancelloing exiting a textbox

HI I have a userform with various textboxes in it. one textbox I want to only contain numbers so I have the following code trigger if a letter is entered

Please Login or Register  to view this content.

This works fine when the property of the userform modal is set to true. the current textbox highlights the current text for me to overwrite. the problem is when I switch the userform to modal = false it doesn't work.

Any ideas why this is and whether there is a simple workaround.

Also the above code will allow eg 100 to be entered or £100. Is there a way to exclude the £100 being accepted.

thanks in advance and happy new year

hi here it is

Please Login or Register  to view this content.